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
Something for the Weekend – SQL Server Links 09/08/13
It’s Something For The Weekend(SFTW) time, I hope you’ve had a great week! Some of you may have noticed that I’ve been a tad quieter in the SQL community...
2013-08-09
14 reads
Blogs
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...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
Forums
ALAMAT BCA KCP Banda 082225313145 WA CS
WhatsApp 082225313145 Jl. Banda No.39, Citarum, Kec. Bandung Wetan, Kota Bandung, Jawa Barat 40115
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:...
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers