Latest Blog Posts
They kinda suck. I mean it is nice that we have the option for the SQL Agent to tell us when a job fails or succeeds, but if you have ever looked at the message, there isn’t much detail in it. Take a look at this (slightly edited) email… Read more
Today 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 back-end and you… Read more
Who has the legal right to access your personal and private digital assets? The answer can be complex, and will depend on where you live, where you are traveling from and to, and whether or not you’ve been suspected of a crime. The rules governing personal digital access are evolving… Read more
Join Webinar on SQL Server 2016 - Always Encrypted / Security. Thu 2/23/2017 from 12 PM to 1 PM
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…