Securing SQL Server Database is a challenging task as there are number of external and internal risks or parameters affecting the Server and its databases. In this section, we...
2018-05-24
22 reads
Securing SQL Server Database is a challenging task as there are number of external and internal risks or parameters affecting...
2018-05-24
1,292 reads
Intro
I’m working on a solution where warehouse uses string codes as the keys for dimensions. Therefore the fact table is...
2018-05-23
115 reads
Microsoft state that enabling TDE (Transparent Data Encryption) usually has a performance overhead of 2-4%. That doesn’t sound like very...
2018-05-23
2,101 reads
Replication means making copy of the objects and moving transaction from primary server to secondary/standby/Slave server. There are two type...
2018-05-23
279 reads
I saw this from Argenis Fernandez, and thought it was wonderful.
1..128 | % { start-job -name ‘job name’ -scriptblock { & sqlcmd -S instanceName -U...
2018-05-23
823 reads
Last week I had the privilege of reviewing possibly the best SQL Server production environment I’ve seen in Canada. During...
2018-05-23
486 reads
A common misunderstanding is that the CONNECT permission lets you do more than just connect to a database. It doesn’t....
2018-05-23
473 reads
I gave a presentation at SQL Day in Poland last week on dbachecks and one of the questions I got...
2018-05-31 (first published: 2018-05-23)
3,071 reads
In a previous post I went through how to Push an image to the Azure Container Registry
Now let’s look at...
2018-06-04 (first published: 2018-05-23)
2,077 reads
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
You can find the slides and SQL scripts for my session “Spice up your...
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Where to download earlier version of SQL server express 2022? Thanks
Comments posted to this topic are about the item Risk Vs Reward, The never...
Hi, to all of you who are using CA certs on SQL Server boxes...
If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?
See possible answers