The Virginia Tour 2016
Three days of presentations in Richmond Virginia. From Naked SQL to Wheel of Doom - there is a wide breadth of knowledge to be shared.
Related Posts:
An Experiment with Deadlocks...
2016-03-11
1 reads
Blog Posts
The Virginia Tour 2016
Long Time Coming
With less than a week before the Richmond SQLSaturday event, I am finally getting this post done – maybe.
This...
2016-03-11
517 reads
Using SELECT INTO with UNION Statements
On occassion, I need to take a number of different result sets and combine them into a single output, which I then want to store in a temporary table....
2016-03-11
4 reads
Using SELECT INTO with UNION Statements
On occassion, I need to take a number of different result sets and combine them into a single output, which...
2016-03-11
426 reads
Availability Group DMVs Reporting Incorrect Values
In my opinion one of the key features of SQL Server 2016 is the rebuilt and optimized log redo mechanism for AlwaysOn Availability Groups. Check out the many new...
2016-03-10
9 reads
Different ways to find Data, log and DB Size
Different ways to get the size of the data , log files and Databases
Using CountersQuerying sysaltfiles & sys.databasesQuerying sys.master_files
SELECT instance_name AS DatabaseName,
[Data...
2016-03-10
1,103 reads
Extraordinary #1
I’ve seen tables that are referenced by many other tables in MSSQL databases and that number was usually being around...
2016-03-10
120 reads
January MVP – Mike Fal
In case you missed it, back in November I blogged about the importance of nominating individuals within the SQL Server...
2016-03-10
382 reads
Now exactly which proposal is this
Introduction
Oft times we are forced into situations where we clearly need to think outside of the box. A case at...
2016-03-10 (first published: 2016-03-01)
1,350 reads
PASS Cloud Virtual Chapter – Call for Presenters
The cloud is calling to you. Or more specifically, Jody Roberts (b | @) and I (b | @) are looking to the community...
2016-03-10
369 reads
Blogs
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers