Are you looking to change jobs? Is your company looking to hire a new SQL Server DBA that's a star? David Poole looks at some of the pitfalls of hiring a star as well as things you may want to consider when looking for a new job.
2004-10-05
11,533 reads
This procedure returns the job history for any jobs run on a given day. The parameter should be entered in mm/dd/yyyy format surrounded by single quotes. I use it to produce a report of any jobs that failed on any given day.It should be created on the MSDB database.Example: EXEC usp_job_history '10/02/2004' This is my […]
2004-10-04
2,194 reads
SQL Server allows data access from many sources, probably any that you could want. Some, however, are easier than others. Have you ever tried to update information in Exchange from SQL Server? Not that easy, but new author Steve Boriotti has written code as well as a short article on how you can make this happen.
2004-10-04
12,980 reads
This is a script you can run on a per-server basis, from any database in Query Analyzer or incorporate into a stored procedure, that will examine all databases on that instance of SQL and show what Maintenance Plan(s) they are part of, if any. Shows clearly any databases that are not currently part of a […]
2004-10-01
537 reads
Get the last date of the month for the given date. Algorithm is:1. Transform given date in “first day of the month” 2. Add a month to result 3. Subtract a day from second result
2007-02-27 (first published: 2004-09-30)
230 reads
A script was recently published (Last_Date_Of_Month) that returns the last day of a given month/year combination. I have simplified and improved on that script by eliminating the need to use a WHILE loop. This new script exploits the flexibility of the DATEADD function which allows you to assign negative numbers (thus effectively subtracting a given […]
2004-09-30
167 reads
playyuer@Microshaoft.com inventhttp://www.Microshaoft.com2004-09-29 updatethere is NOT any relation with global variable: @@DATEFIRSTyou can set datefirst any value from 0 to 7 and result can not be affected!
2004-09-29
171 reads
Hello,I posted this a while ago to several web sites. Someone found an obscure bug in it and I fixed it (newest script attached below). When I posted it to you last time, it didn't show up in any of the categories that I had checked; hmmmm? However, when I searched google, you have it […]
2007-06-13 (first published: 2004-09-28)
1,852 reads
Akeel Din has written an introductory SQL book that is available for free in PDF form. It's also available in print from Amazon if you like holding something real in your hands.
2004-09-28
6,070 reads
2004-09-25
583 reads
By SQLPals
SQL Server instance metadata inventory with PowerShell and SMO The purpose...
Disclosure: this post may contain links to books as an affiliate link. If you...
By Arun Sirpal
Every Claude conversation has a context window. It is the total amount of text...
Comments posted to this topic are about the item Celebrating 30 years of PostgreSQL,...
Hello, has anyone here ever provisioned and actually used an MS SQL Server with...
Comments posted to this topic are about the item No More Deadlocks
After detecting deadlocks in SQL Server 2025 and lowering the time threshold for detecting future issues, when does the Database Engine return to the 5s default interval?
See possible answers