X-XMLA: vii. Partition Management with XMLA
In the 7th article of this series, I will discuss how to manage your partitions with XMLA. We will be...
2012-10-10
644 reads
Lose #5 Before #sqlpass
Win Valuable Prizes!
Impress Your Friends!
This week we’re starting up a health and weight loss competition that I hereby dub #PASSGameOn,...
2012-10-10
978 reads
PASS 2012 Countdown – 4 Weeks To Go
One week down and we are now 4-weeks from this years PASS Summit. Hopefully, you have already registered for the...
2012-10-10
1,140 reads
Update with UPDLOCK
Do you think it’s a good idea to add UPDLOCK hint to the table which will be modified in an...
2012-10-10
1,462 reads
Auditing changes in Merge Replication
One trick I have learned from the folks on the Replication Support Team is how to proactively audit data changes...
2012-10-17 (first published: 2012-10-10)
2,923 reads
Generate Uniqueidentifier with SSIS
If you are trying to generate Uniqueidentifier/Newid() in SSIS data flow, you will soon realize that there is no out-of-the-box...
2012-10-16 (first published: 2012-10-10)
11,545 reads
Slides and Scripts from Idera Auditing SQL Server presentation
I had a few folks ask me for the slides and SQL scripts from the Auditing SQL Server webinar I...
2012-10-10
1,567 reads
Speaking at SQL Saturday #145 in Nashville
I will be speaking at SQL Saturday #145 in Nashville, TN to speak on one of my favorite topics – Virtualizing...
2012-10-10
762 reads
High Energy Plankton – T-SQL Tuesday #35
So, what I’d like to know is, what is your most horrifying discovery from your work with SQL Server?
Related Posts:
Data Platform MVP 2020 August 12, 2020
It's an Honor:...
2012-10-09
6 reads
High Energy Plankton – T-SQL Tuesday #35
High Energy Plankton
In 2022 humans will finally have become their own worst enemies/frenemies. No matter how hard Gore works to...
2012-10-09
1,090 reads
Blogs
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
Forums
RegEx Functions III
Comments posted to this topic are about the item RegEx Functions III
Optimized Locking in SQL Server 2025: Fewer Locks, Less Blocking, and the Cases It Cannot Fix
Comments posted to this topic are about the item Optimized Locking in SQL Server...
Finely Tuned Models
Comments posted to this topic are about the item Finely Tuned Models
Question of the Day
RegEx Functions III
If I run the REGEXP_LIKE() function, does it match values in a case-sensitive fashion, or a case-insensitive fashion by default.
See possible answers