SQL Server : Index Part 2 : Structure of Heap Tables
In the earlier post we tried to understand the difference between a table having clustered index and does not have a clustered...
2013-03-06
2,215 reads
Steps to Preload Data into Tables with SSDT
I am working as the data architect and developer on a modern app build with a the team from Modern...
2013-03-06
1,007 reads
That’s Actually A Duplicate Index
As I’ve worked with clients on performance tuning through index improvements, one of the common areas that I discuss with...
2013-03-06
2,445 reads
Upgrading to SQL Server 2012?
Do you have any plans in place to upgrade to SQL Sever 2012 this year. We are now well into...
2013-03-06
1,058 reads
PowerShell Usage In DBA Work — Case Study 1 / 7
I have been blogged non-technical topics for too long and it is time for me to return to my favourite...
2013-03-06
978 reads
SQL Server Community World Tour with GeoFlow
When I started playing with GeoFlow, I just had to find a way to do something interesting with it. This...
2013-03-06
706 reads
The End of SQLRally in the US
I saw it in the Connector, but just had time to read the minutes to see what was behind the...
2013-03-06
863 reads
Picking a Conference Venue
I was reading about the American Association of Woodturners annual symposium that will be held in Tampa this year (and...
2013-03-05
641 reads
SQL Server 2012 on Microsoft Surface Pro
I received my long-awaited Microsoft Surface Pro 128GB yesterday! The first thing I did was to promptly install SQL Server...
2013-03-05
4,477 reads
Microsoft Data Explorer
Data Explorer (download), which I first mentioned in my blog about PASS Summit 2011 (SQL Server 2012 and other PASS...
2013-03-05
2,000 reads
Blogs
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers