SQL Server in Luxembourg
The SQL Server Luxembourg User Group will be holding its first major event of 2012 on Tuesday 17th January, starting at 4:30pm. The venue will be Microsoft's offices at Cloche d'Or.
2012-01-02
338 reads
Press Release
SQL Saturday #104 - Colorado Springs
Start your 2012 off right with a free day of training in Colorado Springs. Bring the kids as well, as the venue is very family friendly.
2011-12-30 (first published: 2011-12-06)
1,106 reads
Red Gate Software announces DBA in Space competition winner
Find out who has been announced as the winner of Red Gate Software's DBA in Space competition.
2011-12-21
6,017 reads
PASS Data Architecture VC presents Row Versioned Data Warehouses with Jeremy Huppatz
On Thursday December 15th at 8PM Pacific, Jeremy will discuss the strengths and disadvantages of a row-versioned data warehouse design in the context of a real world case study, sharing lessons learnt and demonstrating some of the technologies and techniques used to build a row-versioned data warehouse
2011-12-15
6,329 reads
Vote for SQL Bits 10
Voting is now open to choose the sessions you would like to see at the SQLBits Community Day on 31st March, 2012.
2011-12-13
4,630 reads
Vote for the DBA in Space Finalists
There are 15 finalists in the DBA in Space competition. Cast your vote today, and every day, for the next 5 days to decide who is going into space.
2011-12-12 (first published: 2011-12-08)
3,372 reads
Survey: what features do you want from a backup tool?
We’d like your thoughts on what new features should go into our backup tools. Let us know by completing this short survey.
2011-12-07
1,933 reads
Announcing Red Gate SQL Test
SQL Test is a new unit testing plug-in which allows you to seamlessly write, run and manage tests within SQL Server Management Studio. Download the preview release now.
2011-12-02
3,045 reads
2011-12-02
1,557 reads
DBA in Space - The Answers Revealed
Our space judges are checking over the DBA in Space entries ready to reveal the finalists on December 6th. Meanwhile, we've revealed the answers, so why not take a look?
2011-11-30 (first published: 2011-11-25)
4,446 reads
Blogs
Creating a Striped Backup Set with AI
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
Trace Flag 1448 – Lessons from a Technical Interview
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Disable the sa login in SQL Server (and sleep better)
Disable the sa login in SQL Server (and sleep better)If you run SQL Server...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
SQLPS and syspolicy_purge_history job
The SQLPS.exe file has gone AWOL on 2 of my 4 SQL servers, ie,...
Be Wary of Data
Comments posted to this topic are about the item Be Wary of Data
Question of the Day
Locking Hierarchies
You have a table [dbo].[orders] without a Clustered Index (Heap). The table does not have any other nonclustered indexes! You rund the following command in Read Committed Isolation Level:
SELECTo_orderdate,
o_orderkey,
o_custkey,
o_storekey
FROMdbo.orders
WHEREo_orderkey = 3877;