Why I Have Had a Hard Time Adopting PowerShell
PowerShell has been out for a while. When it first came out, I went and grabbed a copy and tinkered...
2010-04-14
4,284 reads
Blog Posts
A DMV a Day – Day 13
The DMV for Day 13 is sys.dm_io_virtual_file_stats, which is described by BOL as:
Returns I/O statistics for data and log files....
2010-04-13
1,194 reads
Announcing SQLSaturday #46 in Raleigh
SQLSaturday #46 will be held in Raleigh, NC on September 18, 2010, under the direction of Brett Tomson and team...
2010-04-13
487 reads
BLOB Report T-SQL Tuesday #005- Reporting
This month for my second submission into T-SQL Tuesday, I decided to go with something that provides some insight into...
2010-04-13
1,150 reads
Hosting a User Group Meeting - Day of "Bare Bones" Checklist
This actually came as a response to a tweet from Mike Walsh (Twitter | Blog). But here is the barebones checklist I...
2010-04-13
588 reads
oPASS April 2010 Meeting is Tonight
Our next meeting is today, April 9, 2010, from 6-8 pm. Our featured speaker is Joe Webb and he’ll be...
2010-04-13
243 reads
PASS Update #29 (March 2010 Meeting Minutes)
The minutes from the March 2010 Board meeting were released last week and I hope you’ll review them carefully. Viewing...
2010-04-13
467 reads
Reporting Services and Windows 7 Home Premium
Ok, continuing from my post last night about the ‘Run as Administrator’ bug in SSMS, here’s the other half of...
2010-04-13
804 reads
Southern New England SQL Server Users Group
Tomorrow, Wednesday April 14th, is the next SNESSUG meeting. We’re going to get a great presentation from Scott Abrants on...
2010-04-13
741 reads
SQLSaturday #47 Coming to Phoenix!
Just set up SQLSaturday #47 in Phoenix for July 17, 2010 at Devry. Call for speakers is open, good to...
2010-04-13
749 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