Latest Blog Posts
I suspect this may make a few people angry, but I felt the need to share.
I was recently asked to go through my contacts and put together calls with some technologists for a series of discussions. OK. I thought about what we’d need, compared it to a mental list… Read more
The cloud has evolved. Just a few years ago, cloud-based applications were the exception rather than the rule, and on-premises apps were the clear standard for database apps. However, with the numerous advantages of building in or migrating to managed services, the cloud isn’t just a niche anymore. Managed services… Read more
But here is a story of a client that may have too many backups after all.
Our monitoring system found that the backups on a client server had suddenly started running very long. When…
Wow that week absolutely flew by! Here’s what I’ve been reading…
Seatbelt learning with Uncle Buck
Buck Woody goes through how he learns on the move (great article)
I saw this week that there was a new CTP (v1.3) of SQL Server v.Next. I haven’t had a lot of time to work on the Linux version lately, but I thought I’d try and see how well the upgrade went.
As someone who still actively pursues a career in technology, I’m a little on the older side. I got started in tech when a lot of the people I know were still in elementary school. So please understand that when I write the rest of this little… rant.
I read… Read more
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
There is a new website from PASS. Go to Pass.org instead of SQLPass.org. The change does not really concern me but marketing is something I am not into…yet!!!
The one thing I do like is the formatting when viewing on a mobile device. That is very nice. Here is what… 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