Security Basics: The Principle of Least Privilege
Whenever I’m asked about creating a security model for an application or database, I tell folks to follow the Principle...
2017-07-17 (first published: 2017-06-30)
2,968 reads
Don’t Forget the Keys
I was recently given the nod to upgrade my monitoring server from SQL Server 2012 (SP 3) to SQL Server...
2017-07-11 (first published: 2017-06-30)
2,232 reads
Using Organization Hierarchies as Reporting Unit filters with Management Reporter
Well, hello. It has been more than three years since my last blog, since then I have been really busy...
2017-06-30
602 reads
VMworld 2017 USA Sessions
I’m proud to announce that my sessions for this year’s VMworld 2017 conference in Las Vegas have turned up in...
2017-06-30
665 reads
Power BI Custom Visuals Class (Module 57 – Infographic Designer)
In this module you will learn how to use the Infographic Designer Custom Visual. The Infographic Designer give you the...
2017-07-11 (first published: 2017-06-30)
2,161 reads
Implementing Fuzzy Sets in SQL Server, Part 11: Fuzzy Addenda
By Steve Bolton
…………One of the key reasons I looked into the topic of fuzzy sets in the first place was...
2017-06-30
726 reads
Creating a PowerShell Module and TDD for Get-SQLDiagRecommendations
Yesterday I introduced the first command in the SQLDiagAPI module. A module to consume the SQL Diagnostics API.
I have been...
2017-06-30
917 reads
Friday Reading 2017-06-30
Second test for the British & Irish Lions tomorrow, they need this one to keep the series alive. I’ll be up...
2017-06-30
576 reads
SQL Server Permissions and Security Principals on UserGroup.tv
You can now watch my presentation on SQL Server Permissions and Security Principals from SQLSaturday Houston 2017 on UserGroup.tv, a...
2017-06-30
677 reads
Reading the log on SQL for Linux
The SQL Server errorlog is a really helpful place to find all sorts of fun facts about your SQL Server...
2017-06-29
912 reads
Blogs
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
PASS Data Community Summit 2026
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Life hack that has worked well for me
I wrote about this several years ago but will contribute again a life hack...
Trying to make this faster using not exists
Hi I have this query that is slow during the 'not in' part of...
Question of the Day
Switching Schemas I
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers