Azure SQL Database – Automatic Index Tuning
Introduction: -
We live in an era of “Automation”. Planes run on auto pilot mode, cars will soon be auto driven, so why not have auto indexed databases? This article...
2018-03-30
403 reads
Blog Posts
Azure SQL Database – Automatic Index Tuning
Introduction: -
We live in an era of “Automation”. Planes run on auto pilot mode, cars will soon be auto driven, so why not have auto indexed databases? This article...
2018-03-30
13 reads
Azure SQL Database – Automatic Index Tuning
Introduction: -
We live in an era of “Automation”. Planes run on auto pilot mode, cars will soon be auto driven,...
2018-03-30
870 reads
Code that writes code
Code that writes code it one of the best productivity tips I can give you. And no, I’m not talking...
2018-03-30
526 reads
Configuration service database design pattern
In many cases, we are required to store configuration values for an application, application functionalities or user-specific parameters. Normally application-level...
2018-03-30
527 reads
Database Doing DevOps
DevOps. It’s one of the latest buzz words in many technical communities. Database Doing DevOps This phrase, however, is NOT...
2018-03-30
450 reads
I learned about the order of logical operations #SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2018-03-30 (first published: 2018-03-22)
2,644 reads
Parsing the PASS Blog Posts about FY 19 and SQLSaturday
In February PASS President Grant Fritchey posted PASS Priorities FY 19 followed by An Open Letter to SQLSaturday Organizers, and then held...
2018-03-30 (first published: 2018-03-27)
1,717 reads
SQL .NET Requirements
SQL Server Install Requirements
SQL Server Installation requirements indicate .NET 3.5, 4.0, or 4.6 depending on the version. This is not including SSMS. At this point you shouldn’t use SSMS...
2018-03-30
14 reads
SQL Script to find the database & their files details on a SQL Server
Sometimes we need a SQL Script which can gives the below information about the databases created on a SQL Server...
2018-03-30
9,648 reads
Blogs
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Creating a SQL Stored Procedure to Load a SCD2
By DataOnWheels
This is a blog that I am writing for future me and hopefully it’ll...
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Forums
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Running SQLCMD II
Comments posted to this topic are about the item Running SQLCMD II
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers