Intro to SQL Server Automation with PowerShell
March 26th, 2015, a date which will live in infamy!
Well, at least for me it will. March 26th, 2015...
2015-03-30
885 reads
Blog Posts
Latches, Spinlocks & Lock-Free Data Structures Recording
A few weeks ago I have spoken at the SQLRally Nordic conference in Copenhagen about Latches, Spinlocks, and Lock-Free Data...
2015-03-30
1,297 reads
Outlier Detection with SQL Server, part 4: Peirce’s Criterion
By Steve Bolton
…………In the last couple of installments of this amateur series of self-tutorials on outlier identification with SQL Server,...
2015-03-30 (first published: 2015-03-20)
7,037 reads
Outlier Detection with SQL Server, part 5: Interquartile Range
By Steve Bolton
…………The last seven articles in this series of mistutorials on identifying outlying values in SQL Server database were...
2015-03-30
5,754 reads
SQLPort – 5 Years
On 21st of April 2015, SQLPort is preparing a very special event. The reason for this is that on 21st...
2015-03-30
1,097 reads
System Center for the SQL Server DBA Part I: SCOM
Originally posted on Blog Home for MSSQLDUDE:
I’ll start part 1 of the Microsoft System Center series, focused on what...
2015-03-30
991 reads
System Center for the SQL Server DBA, cont’d SCOM Pack for SQL
Originally posted on Blog Home for MSSQLDUDE:
My original posting on System Center Operations Manager for SQL Server DBAs start...
2015-03-30
629 reads
Toshiba Portege Z30 Review
I saw recently that Grant Fritchey wrote a review of his laptop, the Portege Z30. I had noted Grant’s issues...
2015-03-30
1,780 reads
PASS Excel BI VC presents Devin Knight on Getting Started on PowerQuery
Come join us Thursday April 2nd for an Excel BI virtual chapter session at noon central with Pragmatic Work’s Devin...
2015-03-29
676 reads
SQL Server 2014 BI ???? ??????? ????? ??
??????? ??????? ?? ??????! ?????? ????? ? ???? ???? ? ?????? ???? ??? ???? ??????? ????? ?? SQL Server 2014 BI. ????? ??? ?????? ????????? ?????? ???????? ????? ???...
2015-03-29
18 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