Presenting in West Palm Beach on March 22, 2011
I’m pleased to be joining the West Palm Beach .Net group on March 22 to do a presentation on SQL...
2011-03-04
890 reads
Blog Posts
Resource database
Today learned new thing about Resource database, as everybody knows resource database is the system database introduced in sql server...
2011-03-04
1,044 reads
The Power And Pain of Process–Part 1
Part of why I love IT is finding patterns and creating new ones. Patterns by themselves are interesting, but when...
2011-03-04
1,149 reads
Women in Technology PPT Template
Well hey-howdy-hey (as we don’t say in Texas), it’s Women’s History Month! And by all accounts, it’s going to be a...
2011-03-04
1,016 reads
Differences between Merge and Union All transformations in SSIS
What are the differences between Merge and Union All transformations in SSIS ?
The first and most obvious difference is that Merge...
2011-03-03
1,550 reads
Re-purpose my TableSize Script
Last Year I introduced a couple of scripts that I worked on. Those scripts developed into a series covering the...
2011-03-03
461 reads
Re-purpose my TableSize Script
Last Year I introduced a couple of scripts that I worked on. Those scripts developed into a series covering the comparison of some methods and MS provided stored procs...
2011-03-03
2 reads
SSRS – Creating and Using Shared Schedules Part 3
In my two previous blogs in this series, I discussed shared schedules and walked you through step by step instructions...
2011-03-03
967 reads
How To: Automate Continuous SQLServer Activity with Stored Procedures and Powershell Jobs
The Goal
It’s often useful to be able to run a bunch of stored procedures in the background over a period...
2011-03-02
1,127 reads
I Give Up: What IS an MVP?
I’m so glad you asked!
Here’s how it works: Microsoft makes products. (The one I talk about the most is SQL...
2011-03-02
498 reads
Blogs
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
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...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Identities and Sequences III
Comments posted to this topic are about the item Identities and Sequences III
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers