Finding SQL Server Client Ports
I saw a post recently asking if there was an easy way to find the port a client was using...
2010-06-17
1,562 reads
Blog Posts
Important: System Objects/Views/DMV/DMF
Important: System Objects/Views/DMV/DMF This is the some of the list of System Objects/Views/DMV/DMF. Catalog View: All system information is stored...
2010-06-17
1,010 reads
Notes from the June 2010 oPASS Meeting
We had adjusted our meeting date to work around previous commitments for both Jack Corbett and I, and that may...
2010-06-17
542 reads
PASS Update #33
It’s been almost a month since my last update, too long! I’ve put up separate posts on my unplanned and...
2010-06-17
702 reads
Strange but True: Reporting Off of Cubes with Parameters Creates Hidden Datasets
I know, it is strange, but it is true...When you create Reporting Services reports that run off of an Analysis...
2010-06-17
994 reads
What is the Ideal SQL Server Test Box?
I’m thinking about setting up a SQL Server test box in my home office for doing some extensive, real-world SQL...
2010-06-17
420 reads
24 HOP Available
Just a quick note. PASS has made the 24 Hours of PASS available via streaming video. You can check it...
2010-06-16
466 reads
24 Hours of PASS Recordings Now Available
Our most recent 24 Hours of PASS celebrated the SQL 2008 R2 launch. 24 great sessions, 23 of which were...
2010-06-16
586 reads
A Strange Twist in my life
As the plane was landing the other day for SQL Saturday in Pensacola, I was struck by how amazing my...
2010-06-16
798 reads
Daily SQL Server 2008 New Feature – Day 24
Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply...
2010-06-16
382 reads
Blogs
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
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...
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