fn_OBJECT_TYPE
I recently started using OBJECT_NAME, OBJECT_SCHEMA_NAME and OBJECT_ID functions; unfortunately I really could have used OBJECT_TYPE but it doesn’t exist...
2012-10-19
1,256 reads
SQL Server 2008 Diagnostic Information Queries (Oct 2012)
Here is the October 2012 version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements...
2012-10-19
1,712 reads
Reblog: October 12 to October 18
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2012-10-19
520 reads
This December–SQL Server Consolidation and Virtualization
This December (5th - 7th) I will be presenting SQL server Consolidation and Virtualization: Hands-On for Learning Tree in New York....
2012-10-19
933 reads
A Minor Problem of Access
A colleague sent this - they received a trouble ticket where a user who had "all access" to the database couldn't...
2012-10-19
636 reads
this is what I do when I install SQL. How about you?
Whenever I install a standalone SQL instance (installing on a failover cluster adds a few more steps) on a x64...
2012-10-19
877 reads
Address Clean-up for Mail Merge using SSIS
Remember the good ol’ days of going through a list of addresses and manually cleaning up hundreds if not thousands...
2012-10-19
746 reads
MDX #19 – There is more to do to concatenate row values into column
Continuing from MDX #18 – Easy to concatenate row values into column in MDX.
I have not accomplished the goal of concatenating...
2012-10-19
1,456 reads
Visio 2010 Workaround: Application Hangs when opening ‘Database Model Diagram’ template
I received the following error today when attempting to use Visio’s ‘Database Model Diagram’ template under category ‘Software and Database’. The program VISIO.EXE version 14.0.6122.5000 stopped interacting with Windows...
2012-10-18
48 reads
Visio 2010 Workaround: Application Hangs when opening ‘Database Model Diagram’ template
I received the following error today when attempting to use Visio’s ‘Database Model Diagram’ template under category ‘Software and Database’.
The...
2012-10-18
1,186 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