How many times have you wished that there was a parameter for DATEPART to allow you to check for workdays? While many of us may get stuck working 6 or 7 days a week, most of the world revolves on a 5 day work week. Monday through Friday. New author Jeff Moden brings us a method of easily calculating the number of workdays between any two dates.
When IT starts to stand for 'Implement This', even the keenest DBA begins to dream of farming Alpacas as a career-change...and we ask our readers how they would have solved the DBA's dilemma.
There are some issues associated with managing identity columns with replication in your SQL Server database. As with previous releases of software, SQL Server 2005 requires that database administrators use special care when replicating tables with identity columns.
While SQL Server's Profiler is a great tool, it can be hard to work with and we can easily miss information in the results. New author Solomon Rutzky brings us a short article that can help you to better configure your traces to get the information you need.
A primary objective of any analytic architecture is business enablement - the ability to provide business users with access to quality information that can be used to drive decision-making.
This article series features a demo app affectionately named Something Not Entirely Unlike Access, which employs a variety of methods to obfuscate the "Accessian" features.
The sixth installment of the XML Workshop for SQL Server shows how the XML Schemas fit into the XML subsystem. Regular author Jacob Sebastian brings structure to your XML documents with a few schema examples.
Part 6 of "Microsoft Windows PowerShell and SQL Server 2005 SMO" illustrates how to use PowerShell and PowerShell script to backup databases.
BI Architect Bill Pearson begins a three-part sub-series on Caching Options within Reporting Services 2005. In this article, we focus upon Report Session Caching.
Reporting Services makes building rich reports easy, including images and fancy layouts, with a nice wizard. But adding in background images is a little more complex and Andy Warren brings us a quick tutorial for SQL Server 2005's Reporting Services
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
How I used AI for this postChatGPT to generate images based on info specifically...
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
Comments posted to this topic are about the item How Can SQL Server Detect...
Comments posted to this topic are about the item Getting Database MaiL Profiles
Comments posted to this topic are about the item Preserving Data
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers