Quick tip: sp_configure and sys.configurations
In order to query the configuration settings of a server you can run this sproc:
exec sp_configureOn a default install of...
2012-05-16
1,128 reads
Ctrl-alt-geek
Setting up transactional replication using T-SQL
Replication is one of the more complex of the SQL native “HA/DR” technologies. There are a lot of moving parts....
2012-05-15
2,240 reads
Working with bitwise data in SQL Server
I was working with a group of students on a design brief. The brief was to partially implement a database...
2012-05-10
1,050 reads
Locked out of SQL Server.
This is a very cool and useful tip if you find yourself locked out of the sysadmin role in sql...
2012-04-30
2,671 reads
SQL Server 2005 backups in a hung state because of full text search process
I came across an issue today where a backup process was in a blocked state with a wait type of...
2012-04-24
623 reads
Instant File Initialization Security Risk
A while ago I blogged about instant file initialization. A colleague of mine pointed out that there is a small...
2012-04-16
958 reads
Apply SP1 to SQL Server 2008R2 on active/active cluster.
While researching the steps required to service pack SQL Server on an active active cluster I came across a lot...
2012-04-16
926 reads
Comparing users and role memberships between two databases
The other day I was asked to restore a production database into a development environment and then check the database...
2012-03-21
896 reads
Blogs
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Forums
Absolute and Relative References
Comments posted to this topic are about the item Absolute and Relative References
Moving Beyond the Reboot: Finding the Culprit Behind Memory Pressure
Comments posted to this topic are about the item Moving Beyond the Reboot: Finding...
Reserved Words I
Comments posted to this topic are about the item Reserved Words I