Copying your SQL Database
If you have created a SQL Database in Azure (PaaS) and need to make a copy of it on the...
2016-11-07
396 reads
If you have created a SQL Database in Azure (PaaS) and need to make a copy of it on the...
2016-11-07
396 reads
I have a need to encrypt a column within my SQL Database (Azure). I decided to use Always Encrypted. This feature...
2016-11-04
710 reads
I thought that it would be handy to capture some Perfmon graphs of what happens to backup throughput and CPU...
2016-11-03
464 reads
In my last post I showed you how to conduct an assessment using DMA – Database Migration Assessment tool v2.0 This...
2016-11-02
576 reads
One of the benefits of twitter is that you get to hear about new tools quickly, one of the tools...
2016-11-01
666 reads
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
641 reads
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
363 reads
This has absolutely nothing to do with SQL Server, it actually has nothing to do with data but I felt...
2016-10-25
465 reads
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
458 reads
The following DMVs shown within this blog post are some of the more common ones that I am finding really...
2016-10-18
472 reads
By Brian Kelley
The bottom line here is this: the idea that a CSP takes care of...
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
I have been asked to fine-tune the following SQL that was written by a...
In this scenario, I seek assistance in implementing row-level permissions for a table named...
I've tried different credentials, target server versions, etc. hitting our Primavera WSDL. Works great...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers