Playing with Pivot
I’ve been working on some skills, trying to grow some of my T-SQL, and started to mess with the PIVOT...
2014-08-26 (first published: 2014-08-18)
8,206 reads
Generating a restore script
In order to speed up our backups on a large database our team decided to stripe the backup files. In...
2014-08-25 (first published: 2014-08-18)
7,528 reads
SQL Server Keyboard Shortcuts
SQL Server Keyboard Shortcuts for Management Studio
SQL Server Management Studio is filled with lots of optional settings that lets you...
2014-08-22 (first published: 2014-08-18)
9,811 reads
SQL Code Guard v2.6 released
Today we released new version of SQL Code Guard, 2.6
Main changes:1. Bug fixing2. Small GUI and usability improvements3. Fixed support...
2014-08-22 (first published: 2014-08-18)
7,119 reads
Parameterization Part 1: Plan Caching
Many times, when I perform query tuning, the problem that causes the query to perform badly is related, one way...
2014-08-21 (first published: 2014-08-18)
8,637 reads
How To Split Non-Empty Partitions When A Clustered Columnstore Index Exists on The Table
Another pithily titled blog post, but this one revisits the feature of SQL Server 2014 that piqued my interest the most: Clustered Columnstore Indexes. I’ve been working with Clustered...
2014-08-18
381 reads
How to restore database backup in SQL SERVER
In this article, I am going to explain the process of Database restoration using the SQL Server Management Studio. In...
2014-08-17
994 reads
How to take Database backup in SQL SERVER
This article explain the simple way to take up the backup of a database which can be easily understandable by...
2014-08-17
931 reads
Database Creation using SQL Sever Management Studio (SSMS)
In the previous article (Database Creation using Create Database command), I explained the database creation using the Create database command....
2014-08-17
963 reads
Database Creation using Create Database command
In SQL Server, database can be created by 2 ways:-
Using Create Database command Using SQL Sever Management Studio (SSMS).
In this article,...
2014-08-20 (first published: 2014-08-17)
7,844 reads
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers