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…
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…
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…
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.
The method I’m going to show you now, is a nice quick and easy method. (more…)
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…
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?
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…)
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…)
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 up in the changes you need to make, that you forget about scripting these table changes.
Here is a nice trick in SQL Server Management Studio to easily generate table change scripts. Never forget to script your changes again. (more…)
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 is very convenient and best of all, you don’t need to leave the IDE to script table data. So where is this function? Why, under Tasks of course. (more…)
If there is one thing that I always had a pet peeve with, was the table designer column data type default in SQL Server Management Studio. You have no option (that I am aware of) to change the default column data type when creating a new data table in table designer. SQL Server Management Studio decides that using ‘nchar’ is the way to go.
Looking for something else? Try these links instead:
Well if you want to make your columns another data type, you need to manually select the default value and change it to the data type you want. I wanted to find a way to change that default. Turns out that there is an easy way to accomplish this. (more…)