SQL Server Backup and Recovery Fundamentals Presentation
SQL Server Backup and Recovery Fundamentals – February 5th, 2013 A copy of the recording is available here. Code and slides...
2013-01-22
768 reads
TheSqlPro.com - Ayman El-Ghazali
SQL Saturday in Washington D.C. December 8, 2012
This is my first time attending a SQL Saturday event and I’m quite excited. If you live in or near...
2012-11-30
1,220 reads
What if your database server was hacked and all your data was deleted?
Recently in the news an article circulated about a coordinated attack by a team of hackers known as Anonymous. Information...
2012-11-19
498 reads
SQL Server Parallel Data Warehouse (PDW) and SQL Server Fast Track Data Warehouse
The SQL Server Parallel Data Warehouse and SQL Server Fast Track Data Warehouse are very high end builds of Microsoft’s...
2012-11-14
914 reads
SQL Server 2012 Service Pack 1 available for RTM
SP1 for the RTM of SQL Server 2012 has been announced during PASS Summit 2012. It can be downloaded here:...
2012-11-09
738 reads
Listing server and database roles for all logins and users in SQL Server – Part 3 – Using SSRS Reports to Monitor and Fix security problems
Finally the epic conclusion to my three part series about listing server and database roles. In this post I will...
2012-10-23
681 reads
Listing server and database roles for all logins and users in SQL Server – Part 2 – Remote Servers
Building upon the code in my previous post, I will be retrieving permissions information from remote servers that I have...
2012-10-15
408 reads
Listing server and database roles for all logins and users in SQL Server – Part 1 – Local Server
I was approached with a unique problem to solve; find out who has what permissions on my Database Servers. This...
2012-10-08
451 reads
Finding and removing hidden characters in your data using dynamic T-SQL
It has been a long morning for me. It was supposed to be a standard run for our quarterly data...
2012-10-05
674 reads
Running a SQL Server Environment at Home Using Native Boot Virtual Hard-Drives (VHD)
I’ve run into a road block. As a Microsoft Certified Trainer, I have all the software I need to get...
2012-09-17
1,170 reads
Blogs
The Benefits of Teaching
By Brian Kelley
Even preparing for a class or seminar with set materials takes a lot of...
Power BI, Excel, OneLake – Dreams Do Come True!
By DataOnWheels
I can’t believe it’s finally here! A way to have Excel live in OneDrive...
The Book of Redgate: What Our Staff Says
By Steve Jones
This image is from 2010, and it goes along with my last post of...
Forums
Website Stability 2025/12/05
All week we've had issues with the site being up and down. There's been...
403 Forbidden
I created a post (or tried) in the 2022 Admin forum. https://www.sqlservercentral.com/?post_type=topic&p=4694880 But it's...
Question of the Day
Fabric Mirroring
In which versions can I mirror a database from an on-premises SQL Server to a Fabric data warehouse?
See possible answers