How to use Python in SQL Server 2017 to obtain advanced data analytics
On the 19th of April 2017, Microsoft held an online conference called Microsoft Data Amp to showcase how Microsoft’s latest...
2017-06-20
785 reads
PowerSQL By Prashanth Jayaram
Top string functions in SQL Server 2017
SQL Server 2017 has been in the talk for its many features that simplify a developer’s life. With the previous...
2017-06-08
610 reads
Migrate an SQL database from Windows to Linux using backup-and-restore and SMB Protocol
In an attempt decouple systems, we may modularize them. In most cases, we would need to move databases from one...
2017-05-16
542 reads
Installation of SQL Server vNext CTP on Linux Distribution CentOS 7
It was a paradigm shift in December 2016, when Microsoft made their SQL Server database available for Linux; it was...
2017-05-10
1,014 reads
Understanding Database Backup Encryption in SQL Server
Terabytes of data, millions of rows; the entire business depends on this — a database administrator’s responsibility is as massive as...
2017-05-03
573 reads
SQL Server 2016 enhancements – Truncate Table and Table Partitioning
The idea behind this article is to discuss the importance and the implication of SQL Partition and understand the truncate...
2017-04-24 (first published: 2017-04-19)
2,360 reads
SQL Server Database Recovery Process Internals – database STARTUP Command
A database recovery process is an essential requirement for database systems, It can be a tedious job and the process...
2017-03-28
595 reads
Custom keyboard shortcuts in SQL Server Management Studio (SSMS)
People love taking shortcuts because it’s the easiest way to do things faster; computers are no exception. Shortcuts, particularly ones...
2017-03-27
599 reads
Illustration of an example availability monitoring service Using PowerShell and SQL
This article discusses a simple solution of how to monitor SQL service availability across multiple servers and reporting. To build...
2017-03-23
386 reads
PowerShell: Managing Service(s) Using WMI, CIM and Get-Service Cmdlet
Abstract
A common task of any administrator is to manage and maintain the application availability by checking the various services status,...
2017-03-10
3,934 reads
Blogs
Automatic Index Compaction
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
Monday Monitor Tips: Virtual Machine Usage and Cost
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
SQL Server Still Wins
Comments posted to this topic are about the item SQL Server Still Wins
DBCC CHECKDB Limits I
Comments posted to this topic are about the item DBCC CHECKDB Limits I
Question of the Day
DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I specify only the Resource Database?
See possible answers