Tips for Securing SQL Server Database from All Sort of Risks
Securing SQL Server Database is a challenging task as there are number of external and internal risks or parameters affecting...
2018-05-24
1,281 reads
Blog Posts
Toolbox - How Long Has My Server Been Up?
https://imgflip.com/i/2axp6yNo..not that Up (although it is awesome!)
--
As a remote service provider a common request is to follow up after a server...
2018-05-24
326 reads
Dates and Times in SQL Server: more functions you should never use
Previously we looked at four built-in functions to get the current date and time in SQL Server and Azure SQL...
2018-05-23 (first published: 2018-05-16)
3,884 reads
Day 23 Replication
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
273 reads
How to pass data between procedures using temp tables.
In this post I will show how in some cases we can split a long procedure to a small and...
2018-05-23
1,776 reads
Jobs in PoSh to Create a Load
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
821 reads
PoshSSDTBuildDeploy Updated - Now With Pester Tests
Hello!
Some weeks ago I got the tests working on the CI build for PoshSSDTBuildDeploy. The tests were a bit of a mish mash, however they sort of did the...
2018-05-23
8 reads
Pushing SQL Server images to the Azure Container Registry
The Azure Container Registry is an online repository for storing Docker images (think the Docker Hub).
What’s cool about this is...
2018-05-23 (first published: 2018-05-09)
1,431 reads
SSAS Tabular – Fact Table Key Columns Datatype Impact
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
107 reads
The public role
A common misunderstanding is that the CONNECT permission lets you do more than just connect to a database. It doesn’t....
2018-05-23
461 reads
Blogs
Redgate and Rome
By Steve Jones
I’m at the UK Redgate office today, meeting with senior leaders in all areas...
Quick Tip: Check Most DTU Expensive Queries in Azure SQL Database
Optimizing Azure SQL Database performance often begins with identifying the most resource-intensive queries. Understanding...
PowerShell Newbie – Variables
By gbargsley
This is Week 2 of PowerShell Strikes Back – a four-week May series for...
Forums
SSRS Is Dead. Here Are Your Real Options
Comments posted to this topic are about the item SSRS Is Dead. Here Are...
The Distance Metric
Comments posted to this topic are about the item The Distance Metric
The New Wave of Security Threats
Comments posted to this topic are about the item The New Wave of Security...
Question of the Day
The Distance Metric
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers