Extreme Transaction Processing (XTP, Hekaton) – the solution to everything?
(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
My complete last...
2013-08-12
2,181 reads
Environment Variables in SSIS Packages and Configuration Tables
Configuration tables are a best practice in just about any SSIS environment. They make it easy to update multiple packages...
2013-08-12
2,152 reads
DMV-13 : Finding locking & blocking……..sys.dm_tran_locks
sys.dm_tran_locks DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-us/library/ms190345.aspx
Returns information about currently active lock manager resources. Each row...
2013-08-12
1,259 reads
SQLSaturday #235 NYC Super Countdown! - Almost Here!
And so, the countdown begins for the super spectacular,
extraordinarily exceptional, amazingly awesome, fabulously fantastic confab
that is known as SQLSaturday
#235 in...
2013-08-11
864 reads
Colorado SQL Events : August 2013
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...
2013-08-10
564 reads
SQL Server – How to Move Database Files – Data File and Log File – From One Drive Location to the Other
Most of the DBAs at some point of time in their career should have faced at-least one of the below...
2013-08-10
1,398 reads
The Man Who Thinks He Can
Hello Dear Reader! I got a lot of great questions during the 24 Hours of PASS last week and I'm...
2013-08-09
837 reads
Reblog: August 2 to August 8
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-08-09
887 reads
Windows Failover Cluster Monitor
Windows Failover Clusters are fantastic, they provide High Availability for mission critical SQL Server instances and make my life as...
2013-08-19 (first published: 2013-08-09)
2,830 reads
Speaking at PASS Summit 2013
PASS Summit 2013 will be my fifth Summit to attend. I wrote a blog post about how different my fourth...
2013-08-09
644 reads
Blogs
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Cleaning Up My Blog's SEO and AEO with Claude in GitHub Copilot
I’ve been running this blog on Hugo for a long time, and like most...
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