T-SQL Function: EOMONTH
We have all been in a situation where we had to get the last day of the month with T-SQL....
2011-09-13
5,768 reads
Blog Posts
T-SQL Tuesday #22 – Data Presentation
Tuesday is upon us. It also happens to be the second Tuesday of the month and you know what that...
2011-09-13
676 reads
T-SQL Tuesday #22 – Data Presentation
Data Presentation is not just about the look of a report. Data Presentation involves performance, accuracy, display and the business requirements. By giving proper attention to each of these...
2011-09-13
6 reads
T-SQL Tuesday #22 - Data Presentation - My Example with CTE
Hey, everybody! Welcome to T-SQL Tuesday #22! Today's topic is Data Presentation, and the importance of formatting data to the...
2011-09-13
3,848 reads
Checkers, Chess, and Politics
There are few games that don’t have some kind of strategy, from tic-tac-toe on up. Sometimes we take the time...
2011-09-12
1,155 reads
Great Tools for Formatting T-SQL
I have a big rant I add to….well, to every single SQL session I give. That rant is on formatting...
2011-09-12
1,188 reads
Handling Flat File Headers and Errors in SSIS
Using SSIS to load a flat file into a database is a common use of the tool. This works great...
2011-09-12
4,033 reads
How to prevent blocking in your SQL Server database
As a SQL Server DBA, usually the largest databases in size and in number of users that I had to manage was an ERP...
2011-09-12
827 reads
Looking to interact with those proficient in Japanese
In the 1970s my mother and her younger sister married U.S. Marines. Both came to the States when their husbands...
2011-09-12
788 reads
My Peformance Story - September Story Contest - Now Let's See Yours!
Happy Monday, ALL! I recently announced that I am hosting an awesome contest this month, sponsored by Safe Peak, that...
2011-09-12
1,305 reads
Blogs
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...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
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