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
770 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,221 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
502 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
917 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
741 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
682 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
409 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
453 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
675 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,173 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
Impact of Single-Threaded PVS Cleanup on ADR in SQL Server 2019
We want to enable ADR on our SQL Server 2019 instances. I’ve heard that...
Forward Deployed Engineers
Comments posted to this topic are about the item Forward Deployed Engineers
TRY_PARSE vs TRY_CONVERT in SQL Server: From Basics to Practical Usage
Comments posted to this topic are about the item TRY_PARSE vs TRY_CONVERT in SQL...
Question of the Day
DBCC CHECKDB Limits II
I have a SQL Server 2025 database that I want to check for corruption every night. One of the things we do is disable indexes used for ETL loads during the weekend and re-enable them on Monday morning. If we run DBCC over the weekend, are our disabled indexes checked for consistency?
See possible answers