SQLBIGeek's Function Friday - Return First Day of Quarter
Brian K. McDonald
SQLBIGeek
Twitter: @briankmcdonald
Welcome to the first of my “SQLBIGeek’s Function Friday” blog series. I understand that I am posting...
2010-10-24
1,416 reads
Blog Posts
Troubleshooting Connectivity with UDL files
I had a new SSIS package that was ready to deploy to production. It was pulling data from Oracle and...
2010-10-24
12,141 reads
Troubleshooting Connectivity with UDL files
I had a new SSIS package that was ready to deploy to production. It was pulling data from Oracle and this was the first package being placed into production...
2010-10-24
18 reads
3-Weeks to PASS Summit 2010 Countdown -
Only 3 more weeks until the PASS Summit and it’s time for another countdown post. I’ve done a few of...
2010-10-23
752 reads
SQL Rally Precon - We Need Your Vote!
Okay SQL Community, I need your help! Patrick Leblanc, Adam Jorgensen, Mike Davis and myself have submitted a precon for...
2010-10-23
564 reads
Free SQL Server Training for the Week of October 25, 2010
Monday
PASS Data Warehousing/BI Virtual Chapter - Applied MDX - Kevin Geoff
Tuesday
PASS Application Development Virtual Chapter - Refactoring SQL Applications - Jeremiah Peschka
Pragmatic Works - Pro...
2010-10-22
863 reads
New Looks
It’s been quite a few years since I updated the Hawaiian shirt wardrobe. I bought a series of 5 shirts...
2010-10-22
724 reads
PASS 2011 Budget Posted
Bill Graziano posted our 2011 budget today. This runs from Jul 1, 2010, through Jun 30, 2011. I hope you’ll...
2010-10-22
675 reads
Return of Index Analysis Part 4
Let’s Anaylze An Index!We’ve got through the first three parts of this continued series on the Index Analysis query last...
2010-10-22
616 reads
Review: All Things at Once by Mika Brzezinkski
One more from the ‘new book’ shelf at the library, All Things at Once is an auto biography of Mika...
2010-10-22
705 reads
Blogs
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
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 ...
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