8 Weeks In
I’m about eight weeks into my current project and while I’m certain I don’t know it all, I’m finally at...
2011-09-13
542 reads
Blog Posts
Analytic Functions – LAG / LEAD
This post is part of the series discussing the new Analytic functions in SQL Server “Denali”, CTP3.
Analytic Functions in SQL...
2011-09-13
3,438 reads
Analytic Functions – Overview
?This post is the first post in a series discussing the new Analytic functions in SQL Server “Denali”, CTP3, and...
2011-09-13
999 reads
Powershell , Excel charts and data presentation
The topic for T-SQL Tuesday is Data Presentation. Powershell to Excel is a a good way to presenting data, and...
2011-09-13
3,291 reads
SQL Saturday in Kalamazoo This Weekend
If you are going to be in Kalamazoo this weekend and don’t have anything planned. Because, yeah, that happens. Or...
2011-09-13
449 reads
SQL Server Quiz – the last time a stored procedure was executed
A developer rushes up to you and asks "can you tell me the last time this stored procedure was executed?"....
2011-09-13
1,151 reads
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,781 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
14 reads
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
680 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,860 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Forums
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers