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
Gethyn Ellis
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
848 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,102 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,050 reads
Setup a Database Snapshot
I have been tinkering lately with database snapshots and I thought the subject warranted a short post on the subject....
2010-02-23
737 reads
SQL Server 2005 CLR execution error after restore
I recently restored a SQL Server 2005 database to a testing environment. The database contained several CLR assemblies, when the...
2010-02-21
1,117 reads
sys.dm_os_wait_stats
This is a short note explaining he sys.dm_os_wait_stats DMV.
This DMV returns the following columns/values regarding waits encountered by executed...
2010-02-18
1,297 reads
SQL Server - Checkpoint
What is a SQL Server checkpoint?
A SQL Server checkpoint is the process of writing all dirty datafile pages out to...
2010-02-16
6,821 reads
SQL Server 2005 SP4!
Microsoft has recently announced the planned release dates for the next round of SQL Server service packs. SQL Server 2008...
2010-02-14
689 reads
Useful reading this week
This is a short post for a Sunday afternoon, I thought I’d share some useful reading from the week gone...
2010-02-14
859 reads
Blogs
Why Data Analysts Love PostgreSQL (and You Will Too!)
Data analysis is all about wrangling massive datasets. To do that efficiently, you need...
How to Connect Your WordPress Site to the Fediverse
By Rob Sewell
Make it easier for your audience to engage with you by connecting your site...
What I learned volunteering at a children's summer camp
By Rayis Imayev
"Stories are where memories go when they are forgotten" - Doctor Who.(2024-Sep-13) As September quickly...
Forums
GIT Configuration and Automated Release for Azure Data Factory
Comments posted to this topic are about the item GIT Configuration and Automated Release...
How to Add a New Shared Disk to a WSFC as a SQL Resource
Comments posted to this topic are about the item How to Add a New...
Just for fun
Did you ever think that Moses was the first person to download data to...
Question of the Day
Disabling Indexes
I want to disable an index so that it doesn't use any resources and isn't maintained. I am planning to drop this, but don't want to do it now. The index is named LoggerNCI and was created on the dbo.Logger table, on the LogID column. What code disables this?
See possible answers