SSRS R2 - Naming Excel Worksheet Tabs
I was recently asked if it was possible to name an excel tab based on a page in a reporting...
2010-06-21
2,707 reads
Blog Posts
T-SQL - Finding Changes
Someone posted a note recently asking about how to detect the changes in a sequence. Say you have a table...
2010-06-21
4,135 reads
Live Meeting Presentation – ETL with PowerShell
On Tuesday June 22nd 9 PM Eastern I”m presenting ETL with PowerShell for PASS AppDev VC—a virtual chapter of Professional...
2010-06-20
1,026 reads
SQL Server MasterClass Event Review
I often begrudge a 5am start to travel anywhere, let alone to SQL events but this was a trip definitely...
2010-06-19
517 reads
3.15Kw Grid-Tied Solar PV System Online
I took a day off work so I could be here when Namaste Solar and IREA came out to my...
2010-06-18
868 reads
Building a PASS Voting Solution – Part 2
Yesterday I wrote about deciding to build a quick and dirty voting solution. Or to try to at least! Should...
2010-06-18
748 reads
Finding Duplicates
This is just a short post that uses a contrived example to demonstrate how to find duplicate records in a...
2010-06-18
1,112 reads
How Do I ... Get a List of Tables With Data Modifications in a Specific Timeframe?
How Do I ... Get a List of Tables With Data Modifications in a Specific Timeframe?
There was a question on a...
2010-06-18
1,943 reads
June SCSUG Meeting Follow-up
This is a bit later than usual as the meeting was a week ago now, but I wanted to post...
2010-06-18
661 reads
Learn SQL Server 2008 R2 with 24-HOP
Last month, the Professional Association for SQL Server (PASS) held its second 24 Hours of PASS, or 24 HOP for...
2010-06-18
409 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