70-457 Reviewer #02, What is Columnstore Index?
Columnstore index is the new type of index introduced in SQL Server 2012. It is a column based non-clustered index...
2013-07-10
835 reads
Security Questions: Logins Not In Use
As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s, I...
2013-07-10
604 reads
energy
Back when I was trying to start a business and unknowingly heading towards a economic cliff, I read all sorts...
2013-07-10
596 reads
Find out orphan database file on disk
Sometimes you detach databases, or you delete a database which is in restoring status, the data and log file will...
2013-07-09
2,366 reads
PowerSQL – Find OS and Memory Usage Details – Multi Server Script – No Input files
Multi Server script to find OS and Memory details. It doesn’t require a text file as its input but you...
2013-07-09
915 reads
PCI Compliance Presentation on July 17, 2013
Next week I’ll be doing a new presentation about PCI compliance – aka dealing with credit cards – online (follow this link...
2013-07-09
534 reads
Security Questions: Prioritizing Security
As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s, I...
2013-07-09
755 reads
SQL Server Diagnostic Information Queries for July 2013
I have gone through and made some minor updates and bug fixes for all of my SQL Server Diagnostic Information...
2013-07-09
1,157 reads
Power BI for Office 365
Announced at Microsoft’s Worldwide Partner Conference 2013 is Power BI for Office 365:
Power BI for Office 365 is a cloud-based business intelligence...
2013-07-09
1,519 reads
T-SQL Tuesday #44–Second Chances
It’s T-SQL Tuesday time again. This is the monthly blog party, started by Adam Machanic. If you’d like to participate,...
2013-07-09
1,083 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Hyperscale Replicas IV
Comments posted to this topic are about the item Hyperscale Replicas IV
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers