Script: Backup All your Databases
We all know the importance of taking regular backups of our SQL Server databases. This is a useful little script...
2010-03-18
1,707 reads
Gethyn Ellis
Enabling Filestreaming in SQL Server 2008
This is a short post on enabling file streaming. I have read a few sources that cover the same topic...
2010-03-16
729 reads
Setting Up a Server Side Trace
Recently I wrote a short post on the default trace in SQL Server. You can read that here. In this...
2010-03-14
13,995 reads
Setup Database Snapshot against a Mirrored Database (Part 2)
This post is the second post in my series about Database mirroring. For part one is titled Configuring Database Mirroring...
2010-03-11
730 reads
TSQL Tuesday #4: IO
“IO IO, It’s off to disk we go!” was in Mike Walsh’s blog post that introduced this TSQL Tuesday and...
2010-03-09
570 reads
Configuring Database Mirroring in SQL Server
I plan on writing a series of posts on database mirroring, this is the first. Database Mirroring is a new...
2010-03-07
3,696 reads
Time Off, Down Time, Round Up
I have taken some time off this week, I have been to the beach with my two golden retriever puppies....
2010-03-04
679 reads
SQL Server - MVP Deep Dives
I got my copy of MVP deep dives earlier this month and have been making good progress in reading some...
2010-03-02
850 reads
SQL Agent – Giving non-SA users permissions on jobs
There are some new database roles in the MSDB database in SQL Server 2005 that allow you to grant more...
2010-02-28
15,103 reads
Renaming a Standalone Instance of SQL Server
I needed to upgrade the underlying IO subsystem of one of my IO intensive SQL Servers. After some discussion with...
2010-02-25
2,058 reads
Blogs
AI Step 1
By Vinay Thakur
As this is an Artificial Intelligence (AI) World, things are changing. We can see that...
Beginner’s Guide: Building a Dockerized Todo App with React, Chakra UI, and Rust for Backend
In a containerized app, React and Chakra UI provide a robust and accessible user...
A New Word: Nachlophobia
By Steve Jones
nachlophobia – n. the fear that your deepest connections with people are ultimately pretty...
Forums
Lies You Should Believe - Anything is possible
Comments posted to this topic are about the item Lies You Should Believe -...
A Strange Query
Comments posted to this topic are about the item A Strange Query
Primary and Secondary Filegroup
Hello, I am having database primary and secondary filegroup. Few tables/indexes are partitioned on...
Question of the Day
A Strange Query
What does this return?
SELECT x=1 WHERE (SELECT 1) IN ( 1, 2, 3)See possible answers