Pivot and Unpivot table in SQL SERVER
Pivot Table:- Pivot tables are used to summarize and display the data, specially in case of report data by means...
2012-04-14
39,594 reads
Blog Posts
So I started this blog…now what?
Date: May 19, 2012
Location: SQLSaturday #119, Chicago
Abstract:
Ever thought about trying your hand at blogging? Or maybe you’ve started a blog...
2012-04-14
573 reads
Tech Days Albania 2012
I’m very excited for the invitation to present at TechDays Albania 2012, which will be held on April 19, 2012...
2012-04-14
1,835 reads
I am a Linchpin Team Mate
Linchpin People, LLC is an organization led by Brian Moran and Andy Leonard with Mike Walsh and Robert Pearl as...
2012-04-13
1,015 reads
I am speaking at #sqlsat111 on TEMPDB.
I was chosen to speak at SQL Saturday 111 in Atlanta GA this weekend. I will be doing my session...
2012-04-13
577 reads
Querying Microsoft SQL Server 2012 Beta exam (70-461 / 71-461) – My Thoughts
Well I’ve now done the final SQL Server 2012 exam I managed to get a slot booked for. The Querying...
2012-04-13
3,508 reads
SQL Rally Schedule
In case you didn’t see the email come through for PASS this week the SQL Rally schedule is now available. ...
2012-04-13
1,030 reads
SSDT – Installation confusion
SQL Server Data Tools (SSDT) is a Business Intelligence Development Studio (BIDS) replacement, meaning it has a suite of Visual...
2012-04-13
11,507 reads
Table-Valued Parameter Example
I wanted show someone how to use table-valued parameters available in SQL Server 2008 and higher. The main use case...
2012-04-13
3,571 reads
A Strange Day at McDonalds
A few weeks ago I was running errands on a Saturday, with an almost final stop at Home Depot to...
2012-04-12
688 reads
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Midjourney, Healthcare?
Comments posted to this topic are about the item Midjourney, Healthcare?
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers