Storage is getting cheaper and cheaper, which means that more and more SQL Server servers will be incorporating SAN storage as an architecture moving forward. It seems that most DBAs, however, have never worked with this technology. New author Hugh Scott brings us a primer on this Storage Area Networks for DBAs new to this technology.
2005-06-22
15,361 reads
First Day of the Month, First Weekday, Total Days in this Month, Days In First WeeK, Days In Last Week,Total Weekend Days sample output: Given Date:Jul 16 2005 12:00AM First Day of the Month:7/1/2005 First Weekday (sun=1,sat=7):6 Total Days in this Month:31 Days In First Week:2 Days In Last Week:1 Total Weekend Days:10
2005-07-15 (first published: 2005-06-21)
223 reads
While many things in technology decline in price over time, there are few things that do not, space being one of them. In response to other recent writings on the life work balance and other career articles for SQL Server DBAs, new author Sushila Iyer brings us a look at how telecommuting can be of benefit to both the DBA and the employer.
2005-06-21
7,382 reads
It is a known fact, that checksum function can not be applied to text, ntext and image fields. But sometimes it is necessary to compare whether a value in a text field has changed (although it is not guaranteed that checksum generates a unique value, but it still could be used as a good estimator). […]
2005-12-16 (first published: 2005-06-17)
1,174 reads
Sorry fellas but Red-gate bought the site and now claims all copy-rights for its content, so I deleted this script. You can find it in other sites throughout the internet, such as http://education.sqlfarms.com/ShowForum.aspx?ForumID=20
2005-06-16
1,021 reads
This script adds to others posted on this site by formatting and displaying text information about table and index space allocation.
2005-06-13
430 reads
Makes a paged query with the sql parameters to build itand page parameters to filter.Add "No","CurrentPage","TotalPages" coumns to the queryto manage paging at user interface.The query Lose the identity column orderIt works fine for me!
2005-06-12
164 reads
This is just an optimized version of Daniel Payne's two scripts, base64_encode and base64_decode, with changes to end-of-block handling and a bug fix or two. If the encoded string ends in =, the last character is truncated. If ending in ==, two characters are chopped off. That seems better than replacing NUL characters with spaces, […]
2006-12-18 (first published: 2005-06-04)
7,707 reads
This is a replacement script for the first IsDateAHoliday. The first one was too slow and inefficient. This one is much better. Enjoy.IsDateAHoliday is a User Defined Function that accepts a date and returns a 1 if date is a national holiday and returns a 0 otherwise.The holidays are:New years Day, MLK Day, Presidents Day, […]
2005-06-03
417 reads
This Stored Procedure gives you live information of the workload on the reportserver and information about who uses wich report and how often a report is startedA report based on this SP with a short refresh time gives you a live monitoring tool.
2005-06-24 (first published: 2005-06-01)
422 reads
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Comments posted to this topic are about the item The day-to-day pressures of a...
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Comments posted to this topic are about the item Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers