What permissions do I need?
Ever wondered how to tell what permissions are required to run a statement or perform a task? Well, sometimes it...
2016-03-16
479 reads
Catch The Enterprise Scripting Workshop in Orange County, Baton Rouge, Albany, or Atlanta this year!
Sean and I have put together our bazillion (read: like 30 combined) years of SQL Server DBA-ing into one big,...
2016-03-16
486 reads
Time Management–Leadership
To many times data professionals flounder in what some call a pool of uncertainty. The countless tasks, tickets, projects, and emails...
2016-03-16
488 reads
Nested Display Folders in SSAS
Recently it was announced that Power BI would now support the SSAS display folders in “exploration mode”. Exploration mode is...
2016-03-16
1,112 reads
SQL Server 2016 RC0–Management Studio install option has disappeared
If you are trying to install SQL Server 2016 RC0 – which I’m sure you are all doing looking at the...
2016-03-16
727 reads
SQL Server articles
Between attending SQL SKILLS immersion events, trying out for the PFE role at Microsoft I have managed to write some...
2016-03-16
189 reads
Analysis Services: Solving Hierarchy Errors of Uniqueness
Multidimensional Cubes provide speed when it comes to retrieving aggregations that are important to business decisions. Being able to slice...
2016-03-16
572 reads
Index Cannot Be Reorganized…
Working diligently as any good DBA might, you have established maintenance routines for each of the SQL Servers under your purview. Then a small problem occurs: Index Cannot Be...
2016-03-16
31 reads
Index Cannot Be Reorganized…
Working diligently as any good DBA might, you have established maintenance routines for each of the SQL Servers under your...
2016-03-16
542 reads
Compression Performance with Low Key Selectivity
[read this post on Mr. Fox SQL blog] When it comes to enabling data compression in SQL Server I suspect most people don’t do a lot of testing as to the impacts of...
2016-03-15
15 reads
Blogs
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Forums
"Click" your SQL Server into an MCP agent, with RBAC and full security
Hi guys and gals, I've created a system that automatically allows you to "generate"...
Demo Tracking Dropped Objects
Comments posted to this topic are about the item Demo Tracking Dropped Objects
Randomly Selecting Columns and Rows from a Table or View
Comments posted to this topic are about the item Randomly Selecting Columns and Rows...
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers