SQL Saturday Pensacola presentation file downloads
I had a great weekend at my fourth annual visit to Pensacola for SQL Saturday, which had many great sponsors,...
2012-06-12
725 reads
SQL Tact
Recently Used Tables and Databases
Recently developed these queries to assist with the evaluation of development or sandbox environments. Sometimes disk space demands that old...
2012-05-24
1,589 reads
April Hammond .net User Group Presentation - SQL Server Security and Permissions
Here's the slide deck and sample files from last night's presentation at the Hammond .net User Group. We discussed SQL...
2012-04-26
974 reads
SQL Saturday Houston #107 - SQL Server Best Practices with DMV Presentation Files
Thanks for joining me for a standing room only presentation this morning at 9:45am at SQL Saturday #150 Houston. This...
2012-04-21
842 reads
SQL Script Toolbox for Developers
I work with a motley crowd of developers and have the opportunity to give lunch and learn training sessions on...
2012-04-20
686 reads
Using sys.dm_exec_requests to find a blocking chain and much more
As with every good DBA's toolbox, my blocking list query using sys.dm_exec_requests is evolving.
I've added the following features:
The query execution...
2012-04-19
3,460 reads
sys.sql_modules vs. INFORMATION_SCHEMA.Routines
Consider the following two queries meant to search for a keyword in SQL programmability objects.
select s.name +'.' + o.name, o.type_desc, m.definition
from sys.sql_modules...
2012-04-18
1,974 reads
Certification Exams: From the Other Side
Today I took the 70-464 beta exam today "Developing Microsoft SQL Server 2012 Databases" and after spending the last few...
2012-04-06
766 reads
SQLSaturday #107 Houston
About 3 weeks to go until SQLSaturday #107 at YES Prep Public Schools - North Central Campus, 13703 Aldine-Westfield, Houston, TX,...
2012-03-29
1,334 reads
FILESTREAM and Snapshot Isolation Mode in SQL 2008
FILESTREAM and Snapshot Isolation mode are incompatible in SQL 2008.
In SQL 2008 R2 however...
http://msdn.microsoft.com/en-us/library/ms173763.aspx
In SQL Server 2008 R2, snapshot...
2012-03-27 (first published: 2012-03-20)
2,177 reads
Blogs
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Azure SQL Managed Instance Next-Gen: Bring on the IOPS
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Forums
Two foreign keys to the same table. Can't cascade deletes.
Not sure if this is really a relational theory question but it seems about...
Connecting Power BI to SSAS and effective user not working
Hi everyone, Below is a consolidated summary of what we validated Architecture & data...
High Availability setup - has anyone seen this method?
Hi all, I recently moved to a new employer who have their HA setup...
Question of the Day
Encoding URLs
I have this data in a SQL Server 2025 table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers