MSDE – Database Size Limit
Most of you are aware that the Microsoft SQL Server 2000 Desktop Engine (MSDE) limits database size to 2 gigabytes. ...
2009-10-13
6,074 reads
Patrick LeBlanc
Reporting Services - Solving a 401 Error
Reporting Services is a great tool for presenting data to users. However the changes in SSRS 2008 might cause you a problem after installation. New author Patrick LeBlanc has a solution you can try.
2009-10-08
7,662 reads
Windows Internal Database
This past Friday I received a call from our systems team stating that they were running low on Disk Space...
2009-09-22
4,608 reads
SQL Server 7.0 – Transaction Log Not Backing Up
I have not worked with SQL Server 7.0 in a loooong time. So when I received a call from a...
2009-09-14
2,313 reads
Replication – Accommodating Application Inserts
Recently I have been involved in lots of projects involving replication. I have done some things to make replication work...
2009-08-19
1,759 reads
Adding Multiple Columns to a Table With a Single T-SQL Statement
You know, I believe the old saying, “If you don’t use it you will lose it”. Well, I write a...
2009-08-13
38,455 reads
Call For Speakers – SQL Lunch Live Meeting
The Baton Rouge Area SQL Server User Group hosts Bi-Monthly Live Meetings that are 15-30 minutes long the consist of...
2009-08-06
1,524 reads
Deadlock Notifications in SQL Server 2005
Deadlocks do not occur too often, but when they do, it can be a time consuming and frustrating endeavor to track them down. In SQL Server 2000, you could alter the message to ensure these were written to the error log and track them down quickly. In SQL Server 2005, it is a little more tricky, but new author Patrick Leblanc brings us a technique for sending out a notification.
2007-10-10
15,059 reads
Blogs
Common Mistakes in SQL Server – Part 3
Last week we discussed advantages of recompilation in Common Mistakes in SQL Server – Part...
A New Word: Ghough
By Steve Jones
ghough – n. a hollow place in your psyche that can never be filled;...
T-SQL Tuesday: Encryption and Data Protection
I have the honour of hosting this month’s T-SQL Tuesday. In case there’s any...
Forums
The Need for DevSecOps
Comments posted to this topic are about the item The Need for DevSecOps
A Reuseable Window
Comments posted to this topic are about the item A Reuseable Window
Sentiment Analysis with IA
Comments posted to this topic are about the item Sentiment Analysis with IA
Ask SSC