IDENTITY Property in SQL Server
IDENTITY PropertySometimes we need a column whose values can uniquely identifying the rows in the table. To achieve this purpose,...
2009-11-11
1,865 reads
Blog Posts
Looking Back – PASS Summit 2009 Day 3
I started Wednesday planning on going to the Quest sponsored breakfast (plus presentation about DMVs) but when I bailed when...
2009-11-11
701 reads
PASS Summit 2009 – Fun
I’m not a big party guy, and in fact, more than a few people can attest to the fact that...
2009-11-11
812 reads
Planning a Longer Break Soon
I’m sure you know what I mean when I say that I feel like my ability to task switch and...
2009-11-11
480 reads
Speaking at the .NET User Group meeting
When a SQL Server application is under performing, how can you isolate where the actual problem is? Would more memory...
2009-11-11
289 reads
Troubleshooting SQL Server Database Mirroring Problems with Best Practices: Requirements, and the 64-bit Benefit
As mentioned in previous disaster recovery posts and article, during my current mandate I have been tasked with what will...
2009-11-11
11,974 reads
Using a SSRS Report to run SQL Agent Jobs
Data Warehouse latency is often a complaint I have heard from end users when trying to access data via either...
2009-11-11
6,596 reads
And the Winner is........
DB Audit Challenge #1
And the Winner is….
First, I want to thank everyone that participated in the DB Audit Challenge, and...
2009-11-10
814 reads
Article of the Week – Sanjay Mirsha (Data Compression)
Data Compression was introduced in SQL Server 2008. This feature helps compress data inside the database, thus potentially reducing the...
2009-11-10
722 reads
Looking Back – PASS Summit 2009 Day 2
Tuesday started early for me because I had to be at the bloggers table in time for the opening remarks...
2009-11-10
638 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
How to change the FDLaunch Error log file location
The file FDLAUNCHERRORLOG gets created in the default <instance>\MSSQL\Log folder. So far, I've found...
what data type i should use for roversion col and can i use less than greater
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
Radius Latitude Longitude
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers