Deploying Databases From Visual Studio Team System Database Edition
With the GDR release, a whole new set of deployment functionality has become available to VSTS: DB.
Expect an Attack
Most companies in a recent survey expect to get hacked this year. Steve Jones wishes that the technological leaders would help everyone develop more secure code by publishing more information.
Practical Database Change Management (Part 1)
Changing a database an integral and crucial part in every application's life cycle. Part 1 of this series looks at the steps and procedures prior to implementing the change
Retaining historical index usage statistics for SQL Server - Part 2
We look at performing the same task for the sys.dm_db_index_operational_stats Dynamic Management Function (or DMF.) The process is identical, the code is however quite different due to the structural differences between sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.
Tips on Getting HIred – Part 3
Part 1 discussed ways to find opportunities, Part 2 was about how to get more interviews, and today we’ll cover some tips from the employer perspective. Don’t use an AOL.com email address. Seriously. Gmail, Live, Yahoo, all are good, but AOL.com makes...
Adding a Computed Column to a Table (1) - SQL School Video
In this SQL School video, Andy Warren shows how you can alter a table to add a computed column. This is part 1 of 2.
Becoming a DBA
Steve Jones was recently asked how he knows someone is ready to be a DBA. It's an interesting question and he shares some thoughts on this today.
Capturing I/O patterns using Process Monitor
In this article, Edward Elliot shows us how to capture the types, size and location of SQL Server I/O requests.
Expect an Attack
Most companies in a recent survey expect to get hacked this year. Steve Jones wishes that the technological leaders would help everyone develop more secure code by publishing more information.
Expect an Attack
Most companies in a recent survey expect to get hacked this year. Steve Jones wishes that the technological leaders would help everyone develop more secure code by publishing more information.
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
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 ,...
degree of parallelism
Team, I'm trying to figure out what will be the best recommendation to configure...
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