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,101 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
1,835 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,023 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,614 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
598 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
907 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
903 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
842 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...