Latest Blog Posts
So, before jumping into directly in technical details, we all know that time is very important and every second valuable and countable but sometimes every microsecond…
Untrusted constraints can be found when you alter/drop foreign key relationships and then add them back without the proper syntax.
If you are deploying data through several tables, you might want to disable foreign keys on those tables during the deployment to ensure that all the required relationships have a… Read more
The key takeaways from the conference are quite interesting. The announcements from last and this week indicate some challenges in… Read more
Next Monday night is the networking dinner that Andy Warren and I have put together for the last 6 years. Once again, we’ve arranged for everyone in Seattle to come join in.
If you don’t have plans for Monday night, pick a time, and join us at the Yardhouse. We’ve… Read more
If you are attending the PASS Summit next week in Seattle, and want to attend a fun party on Thursday night, come by the Redgate Software booth in the expo hall for your #RedgateRocks bracelet. This is your ticket to admission Thursday night.
Walk down to 1927 3rd Ave between… Read more
Read this and wanted to share as we head to the PASS Summit next week: This is how we do it: Behind the curtain of the O’Reilly Security Conference CFP
This year we’re trying out two ideas on Thursday night, a networking dinner (of a sort) and game night. I wanted to share some ideas on how and why we put these together.
- We’ve long tried to encourage more after hours events with limited success. Of course not all events…
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.
Suppose you want to audit logins for your SQL Server instance. There are multiple ways to do this, but Logon Triggers have a few advantages. First, they… Read more
Part of making a week long trip to a big event like the PASS Summit successful is finding something to do in the evening that recharges you. PASS has a number of events listed for After Hours this year. Steve Jones and I are organizing three of them:
I am pleased to announce that we are launching our next round of all-day precon training session at the upcoming SQL Saturday in Washington DC on Friday, December 2 called ‘The Complete Primer to SQL Server Infrastructure‘.
The focus of the course is to help those new to… Read more
Events like the PASS Summit aren’t just about education. They are a chance to meet new people, get some distance from the day to day problems of work (and life perhaps), and even have some fun. Done well attendees end the week tired and recharged.
How to do… Read more
Question: Who owns your availability groups?
The person who creates the AG becomes the owner by default. Did you know that you can (and probably should) change that the same as many of the other SQL Server objects like databases, jobs, endpoints, etc. Up until this week I did not… Read more
Long ago there were locking / blocking problems with the SELECT INTO statement. That’s not the case anymore and for AdHoc operations and investigation of data SELECT INTO is very helpful.
If you’re not aware of what SELECT INTO is or its benefits here’s an example:
SELECT City, COUNT(1)…
Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them here. In this week’s episode, we discuss the cloud as a service and how it relates to pizza.
The world of the cloud includes a lot of parts and can… Read more
Microsoft Data Warehouse Fast Track for SQL Server 2016 is a joint effort between Microsoft and its hardware partners to deliver validated, pre-configured solutions that reduce the complexity of implementing a data warehouse on SQL Server Enterprise Edition. The Data Warehouse Fast Track program provides flexibility of solutions and customer… Read more
I’ll be attending the 2016 Pass Summit as a part of the Redgate Software crew. I’m not speaking this year, so most of my time will be at the Redgate booth, showing you a few tricks and tips with products and maybe convincing you that we can help your company… Read more
Recently I gave an introductory webinar on how to build an auditing framework for SQL Server. The focus was for those tasked with auditing SQL Server on a regular basis and needing some ideas of how to get started. I talk through some of the challenges as well as what… Read more