The Daily Six Pack: July 28, 2014

Fallback Image

A COLLECTION OF LINKS FOR LOVERS OF I.T. Dirk Strauss . . . . Feature link: ApexSQL Refactor How to Format and Refactor Your SQL Code Directly in SSMS and Visual Studio, Pinal Dave Other Open source projects from Microsoft Make Windows 8.1 Sit, Stay on the Desktop, Shawn Keene How To Get The Boss To Pay For

The Daily Six Pack: July 24, 2014

Fallback Image

A COLLECTION OF LINKS FOR LOVERS OF I.T. Dirk Strauss . . . . Feature link: Upcoming CSharp Features Getting a sense of the upcoming language features in C#, Mads Torgersen Other Absolute beginner’s guide to C#, DevToolsGuy Finding Object Dependencies in SSMS – SQL in Sixty Seconds #071, Pinal Dave How to Evaluate Job Offers, Job tips for geeks 'Father

The Daily Six Pack: July 23, 2014

Fallback Image

A COLLECTION OF LINKS FOR LOVERS OF I.T. Dirk Strauss . . . . Feature link: Software Development Process Seven Changes to Remove Waste From Your Software Development Process, Cecil Dijoux Other SSMS: Activity – All Blocking Transactions, Pinal Dave Tips and tricks for using XAML controls in your universal Windows apps, Windows Apps Team Capitalization Conventions in .NET, Brian Mullen The

Azure Databases – Restore Local Database To Azure

azure databases

Azure Databases - What do you need to do if you have a local database and you want to deploy it to Azure? I saw while researching for this article that there were a few ways to do this. Looking for something else? Try these links instead: Customizing SQL Server Status

The Daily Six Pack: July 21, 2014

Fallback Image

A COLLECTION OF LINKS FOR LOVERS OF I.T. Dirk Strauss . . . . Feature link: Enter Imagine Cup Why you should enter the Imagine Cup, Michelle Feder Other The "Just In Time" Theory of User Behavior, Jeff Atwood Free intellisense add-in for SSMS, Pinal Dave Drag Drop Repo - GitHub Tips 5, Brendan Enrick How to schedule your Windows

Automate Standard Comment Blocks For New SQL Queries

Automate Standard Comment Blocks

Automate Standard Comment Blocks - If you write a lot of SQL stored procedures or functions in SQL Server Management Studio, you might like this tip. Many companies require a standard comment format at the beginning of a stored procedure or function. What would be the easiest way to always have

Customizing SQL Server Status Bar – Know Your Connection

Customizing SQL Server Status Bar

Customizing SQL Server Status Bar - Sometimes I work on a server that has live databases mixed in with test databases. You can obviously see the problem here. Let's delete some test data. Oops, wrong database. Well there is a solution. SQL Server Management Studio allows us to identify the connection.

Easily Generate Table Change Scripts In SQL Server Management Studio

Easily Generate Table Change Scripts

Something I found frustrating when designing databases, were the frequent changes made to tables. Managing the scripts can become quite tricky, especially if you are still in the design phase. This is made worse by code changes or change requests to existing data structures. Sometimes a person gets so caught

Script Table Data In SQL Server Management Studio

Script Table Data

How Do I Script Table Data In SQL Server Script Table Data - I have used other tools to do this for ages. I can't believe that I never knew that it existed in SQL Server Management Studio. Well ok, in my defence it isn't quite the most 'In-your-face' setting. Nevertheless, it