The furore surrounding the recent release of MySQL 5.1 makes Tony Davis wonder if more than a few web 2.0 developers might be peering over the SQL Server Express fence and wondering if the grass doesn't look slightly greener over here.
Many of us deal in date calculations and separating business days from calendar days is always a challenge. New author J Gravelle brings us a new article that talks about this subject as a way of ensuring SLAs are met.
Dynamic management views help monitor SQL Server health and tune performance. Learn how to use DMVs to retrieve critical data on the internal workings of SQL Server.
If you could list all the reasons I work, the number one reason would be to support my family. My definition of support includes spending an appropriate amount of time with family, not just working to support it. I suspect most of you would agree with that as a goal.
I'm continually trying to track down what service packs are installed on various SQL Servers I support. I can never find the right support page on Microsoft's site. So here's an article with all the SQL Server version information I can track down. If you know of any older versions or can help me fill out any missing data, please post in the comments and I'll update the article.
In which Phil Factor's attention wanders whilst reading some software product announcements and imagines what would have happened if the current IT Bloggers had been in charge of the White Star Line at the time of RMS Titanic.
Installing the sample databases in SQL Server 2008 isn't as straightforward as in previous versions. Brian Knight shows what needs to be done in this video.
If you are building packages programmatically and adding data flow components, you will probably need to know the creation name of the component to add. I can never find a handy reference when I need one, hence this rather mundane post.
I always consider taking seminars and technical conferences as a key component in my DBA education framework
I had been doing the validation with a T-SQL User Defined Function (UDF), but it was getting too slow as the number of e-mails grew. I needed a faster alternative, what options do I have?
It is Friday, the queries are running, and nobody is watching the bill. That...
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
WhatsApp:0817-866-887 Jl. Kalierang No.Ruko 3-5, Dukuhturi, Kec. Bumiayu, Kabupaten Brebes, Jawa Tengah 52273 (@bcakcpbumiayu)
WhatsApp: 0817839777 Jl. Raya Bekasi Km. 25 Blok A/17, RW.18, Ujung Menteng, Wil, Kota...
WhatsApp: 0817839777 Jl. Paus No.81, RT.1/RW.8, Wil, Kec. Pulo Gadung, Kota Jakarta Timur, Daerah...
When running bcp on Linux, what is the field terminator?
See possible answers