A COLLECTION OF LINKS FOR LOVERS OF I.T. Dirk Strauss . . . . Feature link: Identify Locked SQL Table How to Identify Locked Table in SQL Server?, Pinal Dave Other Experiences from using existing projects within VS2015, Michael James How to change your default save locations on Windows 10,…
A COLLECTION OF LINKS FOR LOVERS OF I.T. Dirk Strauss . . . . Feature link: SQL Injection Free Webinar Free recorded webinar on Pluralsight: Why SQL Injection Remains the #1 Web Security Risk Today, Troy Hunt Other Visual Studio Code and Docker, Sean McBreen SQL Server Management Studio Query Designer Shortcuts, Babu Akkandi…
A COLLECTION OF LINKS FOR LOVERS OF I.T. Dirk Strauss . . . . Feature link: NSA Converts Words To Searchable Text How the NSA converts spoken words into searchable text, Dan Froomkin Other New in Visual C# 6.0, Visual Basic 14: New Null/Nothing Check, Peter Vogel How to download and…
Connecting SQL Fails after waking your PC from hibernation? Well then the solution might be a really easy one. Here is a quick post on fixing this annoying issue. (more…)
A COLLECTION OF LINKS FOR LOVERS OF I.T. Dirk Strauss . . . . Feature link: Einstein Regarding Haters Read what Albert Einstein wrote to Marie Curie about haters, Mike Fenn Other Introducing Microsoft Imagine, Kristen Hamilton Preventing a screen from closing in the LightSwitch desktop client, Jan Van der Haegen What's new…
A COLLECTION OF LINKS FOR LOVERS OF I.T. Dirk Strauss . . . . Feature link: Swift Introduction Part 2 An Introduction to Swift: Part 2, Michael Musallam Other Integrating “News” in the VS IDE … a cool extension update!, Willy-P. Schaub What is the difference between Build and Rebuild in Visual Studio?, Dean…
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…
Execute Script Error – Imagine my surprise when I tried executing a rather large SQL script (255 Mb) and received an error telling me that there was ‘Insufficient memory to continue the execution of the program. (mscorlib)’. You might be wondering why I would even have such a large script to begin with.
Looking for something else? Try these links instead:
Well I had to import data from a file that I didn’t have access to any more, so I decided to script the table contents from the live database and import into my dev database for testing. Trying to run the query produced the error and I had to find an alternative way to get the data into my table. (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…)
A COLLECTION OF LINKS FOR LOVERS OF I.T. Dirk Strauss . . . . Feature link: Transact SQL Transact-SQL Named 'Programming Language of the Year' for 2013, David Ramel Other Source Code in TV and Films, John Graham-Cumming Team Foundation Server Usage at Microsoft, Zain Naboulsi How to Validate Syntax…