The Daily Six Pack: February 7, 2014

A COLLECTION OF LINKS FOR LOVERS OF I.T. Dirk Strauss . . . . Feature link: Visual Studio Extension Visual Studio Extensions - from Add-in to VSPackage, Kornfeld Eliyahu Peter Other Learning SSIS – Where Do I Start? – Notes from the Field #014, Pinal Dave January Optional Updates for Windows…

Continue ReadingThe Daily Six Pack: February 7, 2014

The Daily Six Pack: February 6, 2014

A COLLECTION OF LINKS FOR LOVERS OF I.T. Dirk Strauss . . . . Feature link: Satya Nadella Satya Nadella, the third CEO of Microsoft Other The Past, Present, and Future of C#, Blair Greenwood C# among more popular programming languages for 2014, Sam Sabri Using LINQ with Collections that Don't…

Continue ReadingThe Daily Six Pack: February 6, 2014

Prevent Accidental Table Data Deletion In SQL Server Management Studio

Prevent Accidental Table Data Deletion – How do we secure our production database against simple errors that could cause quite a problem. As a developer, I mainly work on my database while being in a development environment. It is only after the development is one that some of the work is done against a live database. Let’s have a look at some solutions using SQL Server 2012. (more…)

Continue ReadingPrevent Accidental Table Data Deletion In SQL Server Management Studio

The Daily Six Pack: February 3, 2014

A COLLECTION OF LINKS FOR LOVERS OF I.T. Dirk Strauss . . . . Feature link: Effective Debugging Tips 10 Effective Debugging Tips for .NET Developer, Abhijit Jana Other Tray notifications in C# and PowerShell, Iris Classon Footage of Guardian Destroying Snowden Hard Drives Download Crystal Reports for Visual Studio 2012…

Continue ReadingThe Daily Six Pack: February 3, 2014

Automate Standard Comment Blocks For New SQL Queries

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 this text available?

Looking for something else? Try these links instead:

Some might think to have it in a text file and just copy and paste every time you create a new script. Here is a little trick for those lazy developers (in other words, everyone). (more…)

Continue ReadingAutomate Standard Comment Blocks For New SQL Queries

The Daily Six Pack: January 31, 2014

A COLLECTION OF LINKS FOR LOVERS OF I.T. Dirk Strauss . . . . Feature link: Visually Creating Snippets Visually Creating Snippets In Visual Studio, Visual Studio Blog Other Beginning LightSwitch in VS 2013 Part 6: More Control! Customizing the app with JavaScript & CSS, Beth Massi 5 Tips for getting…

Continue ReadingThe Daily Six Pack: January 31, 2014

Customizing SQL Server Status Bar – Know Your Connection

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. You do this by changing the colour of the status bar below the SQL Query Window. Customizing SQL Server’s Status Bar is so easy, it is again one of those tricks I never knew existed. It is ‘hidden’ in plain sight though and adds a lot of value to your productivity. (more…)

Continue ReadingCustomizing SQL Server Status Bar – Know Your Connection

The Daily Six Pack: January 30, 2014

A COLLECTION OF LINKS FOR LOVERS OF I.T. Dirk Strauss . . . . Feature link: Team Foundation Server Free Version Control for Small Teams: Team Foundation Services, Peter Vogel Other Zip Archives in C# 5.0 (.NET 4.5), Sumit Maitra TAWDRYYARD: NSA Exploit of the Day, Bruce Schneier A Developers Guide…

Continue ReadingThe Daily Six Pack: January 30, 2014