Microsoft database migration tools
There are various Microsoft tools that you can use to help you migrate your database (updated 8/9/17):
Data Migration Assistant (DMA)...
2017-03-29
1,113 reads
Blog Posts
Power BI Custom Visuals Class (Module 44 – Attribute Slicer)
In this module you will learn how to use the Attribute Slicer Power BI Custom Visual. Using the Attribute Slicer...
2017-03-29
1,153 reads
Random Blogging Challenge Results
The winner is: Everyone.
Hey, the challenge was random. I didn’t promise a prize or a winner. Instead, I suggested everyone...
2017-03-29
643 reads
Restoring an entire SQL Server user databases with PowerShell using dbatools
All the good DBAs backup their databases.
A significant amount of SQL DBAs use Ola Hallengrens maintenance solution to do so.
This...
2017-03-29 (first published: 2017-03-18)
3,041 reads
Speaking on Consolidated Essential Performance Health Check using PowerShell – SQLSaturday (Orange County)
on Apr 1st 1.30 pm, I will be presenting “consolidated essential performance health check using powershell” @ sqlsaturday, Orange County, if...
2017-03-29
447 reads
SSMS – Not a Valid Value for Property Width
I’ve had this happen a couple of times with a recent build of SSMS. Something went wrong – resolution change maybe...
2017-03-29
1,249 reads
Trouble Shooting Little Jewel
I didn’t know about this little gem, so I shared it with my team and they didn’t know about it...
2017-03-29
703 reads
Using SQL Client Aliases
SQLServerCentral.com recently published my case study on how my company implemented Windows Containers running SQL Server to streamline our QA...
2017-03-29
1,638 reads
Using SQL Client Aliases
SQLServerCentral.com recently published my case study on how my company implemented Windows Containers running SQL Server to streamline our QA...
2017-03-29
173 reads
Watch Your DataTypes in Aggregates–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-03-29
1,000 reads
Blogs
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Forums
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers