Latest Blog Posts
Just last week we had the fantastic opportunity to present at Microsoft Ignite 2017 in the Gold Coast on Azure Cognitive Services – and we had an absolute blast of a time!
Wait a minute! Almost forgot.
More great news coming soon, stay tuned, subsribe to twitter https://twitter.com/SQLCodeGuard if you don't want miss somthing fun.
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.
If you’ve worked with SQL Server development and database projects, you might have heard about DACPACs. However, if you haven’t, this was a concept that didn’t seem… Read more
I just wanted to remind everyone that the SQL Saturday in Chicago is coming up, and that both Adam Machanic and I are holding precons the Friday before the event. The SQL Saturday in Chicago this year has hit peak capacity two months before the event. However, if you enroll… Read more
Restoring a backup file is pretty easy right?
RESTORE DATABASE [Test] FROM DISK = 'C:\backups\backup.bak';
Ok, but what if more than one database backup is stored in that single backup file? Didn’t know you could do that?
Yep. You can.
BACKUP DATABASE [Test] TO DISK = 'C:\backups\backup.bak'; BACKUP DATABASE [AdventureWorks2014]…
Continuing on my series in working with Docker on Windows, I noticed that I always open up a remote powershell window when working with Docker on servers. Nothing wrong with this, if you want to know how to do that you can follow my instructions here.
However what if… Read more
The response to our most recent job position was incredible, and I’d like to thank all of the folks who responded and submitted their CVs to us for consideration. In the end, we had one open position, and we selected the most qualified candidate for the position.
I’d like to… Read more
I’m honored to be selected to speak at SQL Bits 2017 this April in Telford. This is my favorite SQL Server conference, and it’s always a joy to attend. Especially the Friday night party, where everyone seems to have a lot of fun.
I’ll be presenting “Including Your Database in… Read more
On Thursday, February 23rd at 3 PM EST I’m giving a webinar on designing a successful database security model with SQL Server.
Here’s what I’ll be covering:
You’re building a new application using SQL Server as a… Read more
In this module you will learn how to use the Waffle Chart Power BI Custom Visual. The Waffle Chart visual is most useful for presenting a percentage of data. This chart is a great option to choose over other visuals like Pie Charts, which are not great at showing proportions… Read more
Issue: I am trying to load data from Excel 97 – 2003 sheet into a database table. I have written a simple SSIS package to do that, but unfortunately, it fails with error: –
Microsoft (R) SQL Server Execute Package Utility Version 11.0.6020.0 for 64-bit Copyright (C) Microsoft Corporation.… Read more
It took me quite a while to figure out how to sign a SQL Server CLR Assembly (like a CLR stored procedure / function / trigger etc) in VS 2015.
If you google “sign a SQL Server CLR Assembly”, you will most likely find out content published 5+ years ago… Read more
Previously we discussed about using memory optimized tables to replace table variable and global temp table, this time we will replace local temp tables and seek for performance gain. We all use…
One of my client's existent SSIS solution contains a use of multiple SQL execute tasks which are configured to use external files with a complicated SQL code.…
One question constantly comes up; What should the Cost Threshold for Parallelism be? The default value of 5 is pretty universally denigrated (well, not by Microsoft, but by most everyone else). However, what value should you set yours to?
What Do Your Plans Cost?
I have a question right back… Read more
Growing up my mother used this phrase quite a bit. Penny wise, pound stupid. (In case you didn’t know the pound is the British equivalent of the dollar.) Basically, it means paying attention to the small stuff at the expense of the big stuff. My favorite example of this… Read more