SQL Server Cloud Migration Part I
A SQL Server migration with minimal business impact while synchronizing schema and data.
The PoSh DBA – Getting to know PowerShell
Although it was primarily designed for System Administrators, PowerShell is now extending its use to Database, SharePoint, Exchange and all Microsoft products. In this article Laerte Junior offers an introduction to PowerShell and describes how DBAs can use PowerShell to automate repetitive tasks. He also explains when to use PowerShell instead of, or in addition to, T-SQL and SSIS.
Can SQL Server do ‘Big’?
Can SQL Server scale? Phil Factor has a few thoughts on the capacities that SQL Server can scale to.
SQL Server Reporting Services Report Manager Tips and Tricks
Dattatrey Sindol shares his tips and tricks on SQL Server Reporting Services Report Manager. He provides guidance on Customizing Report Manager Header/Title, Uploading Custom File Types to Report Manager, and Enable My Reports Feature.
Blocking Chain (SQL Spackle)
Problems with blocking processes can be easy to identify with SQL Server DMV's.
Opportunities Abound
We have so many ways in which we can grow our SQL Server careers. Steve Jones shares a few today.
TribalSQL: 15 New Voices in SQL Server
MidnightDBA and Red Gate have joined together to produce a new book on SQL Server, written by 15 first-time authors. The resulting book, TribalSQL, includes everything you should know about SQL Server that isn’t taught in traditional training, they call it Tribal knowledge.
Databases and Dominoes
A Dominoes game of Texas 42 inspires Joe Celko to explore unusual uses for check constraints and views. Sometimes, the best way of discovering useful SQL techniques is to tackle the more unusual problems.
Job Worries over Automation
Are you worried about your job in the future? Steve Jones thinks you shouldn't be.
SQL Saturday #190 Denver
Join us at SQL Saturday Denver on September 28. SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This SQL Saturday includes a number of options for pre-conference training in Denver, including a free session presented by Steve Jones.
Blogs
Runing tSQLt Tests with Claude
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Getting Your Data GenAI-Ready: The Next Stage of Data Maturity
By James Serra
I remember a meeting where a client’s CEO leaned in and asked me, “So,...
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Forums
The Long Name
Comments posted to this topic are about the item The Long Name
Eight Minutes
Comments posted to this topic are about the item Eight Minutes
T-SQL in SQL Server 2025: Fuzzy String Search I
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
The Long Name
I run this code to create a table:
When I check the length, I get these results:
A table name is limited to 128 characters. How does this work?