Dedupe Data CTE
As a DBA working with SQL Server, some data issues arise that need to be fixed. One such data issue...
2011-03-21
1,394 reads
Blog Posts
Dedupe Data CTE
As a DBA working with SQL Server, some data issues arise that need to be fixed. One such data issue is the duplication of data. Duplicate data can happen...
2011-03-21
22 reads
Diskpart command line utility
To get the disk information internal. there is a utility called diskpart this is good utilityto understand your disk information....
2011-03-21
467 reads
Next Up: SQL Connections!
SQL Saturday #70 is officially in the books. There's some administrative stuff: I will do a blog post about lessons...
2011-03-21
788 reads
SQL Server Connections in a week
I’m heading to SQL Server Connections next week, part of the DevConnections conference featuring a whole slew of technologies. Once...
2011-03-21
792 reads
SQL Server Crossword #3
To mark my 30th Birthday today, as promised here’s a SQL Server Crossword for you to enjoy. You can find the previous...
2011-03-21
1,406 reads
SSIS Foreach File Enumerator returns more files than expected by appending a wildcard (*) to the file mask
While working on a recent project for a customer that involved importing both Excel 97-2003 and Excel 2007/2010 files, I was...
2011-03-21
1,312 reads
Einladung zum SQL Server Performance Tuning und Troubleshooting Workshop, 24. Mai 2011 in Wien
Sind Sie schon mal in das folgende Problem-Szenario gelaufen, und mussten Ihren wohlverdienten
Feierabend und die Vorfreude auf das Wochenende opfern:...
2011-03-20
813 reads
PASS Prof Dev Blog
In case you hadn't noticed, PASS has a number of virtual chapters. Many of the virtual chapters broadcast LiveMeetings about once...
2011-03-20
1,130 reads
Tampa IT Camp 2011 Presentation
I presented a one hour session at Tampa IT Camp on SQL Server PowerShell Extensions (SQLPSX): “In this session we...
2011-03-20
558 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