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
778 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
601 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
536 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,008 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
569 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,356 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
588 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
587 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
381 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,749 reads
Blogs
The Mystery of SQL Server 2025’s New Tricks – Scooby Dooing Episode 5
Every Scooby-Doo mystery starts with a haunted house, a strange villain, and a trail...
A Prompt AI Experiment
By Steve Jones
Prompt AI released recently and I decided to try a few things with the...
SQL Server Is Slow (part 1 of 4)
By Kevin3NF
How should you respond when you get the dreaded Email/Slack/Text/DriveBy from someone yelling at...
Forums
how to get notification that my database has corssed 8gb
i have sqlexpress on rds, is there any way i can get notifacation that...
SQL Server, Heaps and Fragmentation
Comments posted to this topic are about the item SQL Server, Heaps and Fragmentation
Stairway to Azure SQL Hyperscale – Level 2: Page Server Architecture Explained
Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...
Question of the Day
SQL Server, Heaps and Fragmentation
A table without a clustered index (heap) will NOT suffer from fragmentation during frequent updates or deletes. True or False?
See possible answers