Always Encrypted Column Encryption
I have a need to encrypt a column within my SQL Database (Azure). I decided to use Always Encrypted. This feature...
2016-11-04
716 reads
All About SQL
SQL Server Backup Compression
I thought that it would be handy to capture some Perfmon graphs of what happens to backup throughput and CPU...
2016-11-03
476 reads
SQL Server DMA v2.0 – Migration Time
In my last post I showed you how to conduct an assessment using DMA – Database Migration Assessment tool v2.0 This...
2016-11-02
587 reads
SQL Server DMA – Data Migration Assistant V2.0
One of the benefits of twitter is that you get to hear about new tools quickly, one of the tools...
2016-11-01
677 reads
SSMS 2016 Bug
I have been using SSMS (SQL Server Management Studio) 2016 build number 13.0.15900.1 and noticed that if you wanted to...
2016-10-27
647 reads
More bytes for Row versioning
I like row versioning– see this link for more details: https://technet.microsoft.com/en-us/library/ms189122(v=sql.105).aspx If your database is enabled for one of the...
2016-10-26
367 reads
Azure App Service Companion for iOS
This has absolutely nothing to do with SQL Server, it actually has nothing to do with data but I felt...
2016-10-25
468 reads
Another way to move SQL DB to Azure
About 8 months ago I wrote an article (http://www.sqlservercentral.com/articles/SQL+Server/139998/ ) where I showed you how to migrate your “earth” SQL Database...
2016-10-20
463 reads
Azure SQL Database DMVs
The following DMVs shown within this blog post are some of the more common ones that I am finding really...
2016-10-18
478 reads
The dark side of Fn_dump_dblog
I want to show you what happens when you keep using the undocumented fn_dump_dblog function. (For example if you are...
2016-10-24 (first published: 2016-10-17)
1,970 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers