2012 DDL for Roles
TweetG’day,
I’m extremely pleased that Microsoft are continuing their commitment to provide full DDL to preform TSQL operations that have previously been preformed using stored...
2012-04-22
1,329 reads
Blog Posts
SQLSaturday in Houston Presentation
Thanks to everyone who attended my presentation “Scaling SQL Server to HUNDREDS of Terabytes” at Houston SQLSaturday.
Here is the PowerPoint presentation: Scaling...
2012-04-22
922 reads
SQL Saturday Houston #107 - SQL Server Best Practices with DMV Presentation Files
Thanks for joining me for a standing room only presentation this morning at 9:45am at SQL Saturday #150 Houston. This...
2012-04-21
843 reads
Temporary Post Used For Theme Detection (a2bb2736-7786-4122-aa80-2ea5c4a91819 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
This is a temporary post that was not deleted. Please delete this manually. (a9a8917a-7430-47c6-8534-f96e3e4e0618 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
2012-04-21
771 reads
CONCAT in SQL 2012
SQL Server 2012 introduces a brand new string function called CONCAT(). CONCAT() string function allows you to concatenate up to 255 string or variable values in to one single...
2012-04-20
81 reads
Im in Houston Today (and this weekend too)
I’ll be spending the day with the 2011 Idera ACE’s (aka the old aces) and the 2012 Idera ACES (the...
2012-04-20
690 reads
SQL Script Toolbox for Developers
I work with a motley crowd of developers and have the opportunity to give lunch and learn training sessions on...
2012-04-20
687 reads
SQL Server: Measuring The Index Fragmentation
In my previous post , I have explained about the different types of fragmentation and how it will affect the query performance....
2012-04-20
11,714 reads
Becoming the dumbest guy in the group
“Why I joined Linchpin People as a Teammate”
It was announced publicly this past weekend at SQL Saturday #111 that I...
2012-04-19
768 reads
CONCAT in SQL 2012
SQL Server 2012 introduces a brand new string function called CONCAT(). CONCAT() string function allows you to concatenate up to...
2012-04-19
464 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers