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
777 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
598 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
529 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,005 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
565 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,350 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
583 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
579 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
380 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,516 reads
Blogs
Master SQL Subqueries with This Free Course
Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World...
Using Flyway Prepare for State-Based Deployments
By Steve Jones
One of the neat enhancements made to Flyway was the addition of state-based workflows...
How I Migrated to Azure PostgreSQL Flex from Single Server
I did a couple of posts previously on dumping/restoring Azure PostgreSQL databases and also...
Forums
When trying to use a LocalDB, I get an error
I tried to find an appropriate forum to post the question. This one seems...
Resolving Access Denied Errors During SQL Server Database Attachment
Comments posted to this topic are about the item Resolving Access Denied Errors During...
The Lesser Used Functions
Comments posted to this topic are about the item The Lesser Used Functions
Question of the Day
SQL in an Azure VM Backup
If I use the Azure Backup service for automated backups of my SQL Servers in Azure VMs, how often can I configure log backups? (as of Dec 2024)
See possible answers