Dots, Skills, and SQL Clone: A Contest from Redgate
Redgate just launched SQL Clone, a new product that can provision copies of databases in seconds. By copies, I mean...
2017-03-15 (first published: 2017-03-06)
1,504 reads
SQL Clone and a Little Competition
Redgate has released a new product, SQL Clone. I’ve already talked about how excited I am about it. Now, it’s...
2017-03-13 (first published: 2017-03-06)
1,761 reads
Using GROUP BY instead of DISTINCT
Recently, Aaron Bertrand (b/t) posted Performance Surprises and Assumptions : GROUP BY vs. DISTINCT. In it he says he prefers GROUP...
2017-03-06
2,445 reads
SQL Server Fixed Role Permissions
It is very important to understand who has what level of access within the server and databases on that server. Sometimes we see users being granted server or database...
2017-03-06
28 reads
SQL Server Fixed Role Permissions
Roles and Permissions
Some of my recent articles have been focused on permissions and security. There is good reason for that – security...
2017-03-15 (first published: 2017-03-06)
3,108 reads
Hands-On Data Analysis With Power BI Desktop at PASS BA Marathon
I’m delighted to announce I’ll give a session at the next PASS BA webinar marathon. The topic of this marathon...
2017-03-06
408 reads
Generating Frequency Table
This week’s blog post is rather simple. One of the main characteristics of a data set involving classes, or discrete...
2017-03-20 (first published: 2017-03-06)
8,539 reads
Quickly Creating Test Users in SQL Server with PowerShell using the sqlserver module and dbatools
One of the most visited posts on my blog is nearly two and half years old now – Add User to...
2017-03-16 (first published: 2017-03-06)
1,740 reads
Monday Coffee 2017-03-06
Last week Docker announced the availablity of Docker Enterprise Edition. The existing version of Docker that I’ve been using has...
2017-03-06
350 reads
The Ebb & Flow of Community Participation
It’s an interesting moment when you discover the SQL community (or any other I suppose). It’s the moment of finding the...
2017-03-05
441 reads
Blogs
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Forums
How have you encouraged communication at work?
I do have a question. At work, some groups of people have an inordinate...
What Did Healthy Look Like?
Comments posted to this topic are about the item What Did Healthy Look Like?
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers