Establishment of a successful business requires the proper maintenance of the data. SQL Server is one the popular platform for the same. In SQL Server, a proper strategy has...
2017-03-20
6 reads
This week’s blog post is rather simple. One of the main characteristics of a data set involving classes, or discrete...
2017-03-20 (first published: 2017-03-06)
8,483 reads
I believe in DevOps.
Actually, that’s a pretty horrible way to put it. It’s not about belief, like keeping Tinkerbell alive.
I...
2017-03-20 (first published: 2017-03-07)
1,842 reads
TDE (Transparent Data Encryption) encrypts the data files at rest but don’t forget that it also encrypts your backup file...
2017-03-20
321 reads
In a previous post I wrote about how easy it was to restore a whole SQL Servers user databases from...
2017-03-20
1,012 reads
Any object within a database in SQL Server has what is called a four part name. Which rather implies four...
2017-03-20
371 reads
On Thursday, March 23rd, at 2pm Eastern, I will be hosting a webinar with Argenis Fernandez from Pure Storage where...
2017-03-20
324 reads
By David Postlethwaite
David is delivering a talk An Introduction to SQL Server Query Store at SQL Saturday Iceland today - this...
2017-03-18
728 reads
As this is being posted I’m on my way up to Dublin Airport to catch my flight to Iceland ready...
2017-03-17
298 reads
In conjunction with the webinar I gave last month for MSSQLTips, I’ve started an article series on application database security...
2017-03-17 (first published: 2017-03-06)
2,138 reads
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Hello We recently encountered an issue where a SQL table unexpectedly grew in size...
Comments posted to this topic are about the item The New World Of AI...
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
What does this return on SQL Server 2025?
select bit_count(null)See possible answers