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-10
81,308 reads
Blog Posts
Good News for IT professionals? - Ray of Economic Light Shines in July........
Here's some upbeat info to share as the week kicks off to a new start!
Data just recently released by the Department of...
2009-08-10
682 reads
Interview on SQLAuthority.com
Well-known Indian SQL MVP Pinal Dave has posted a short interview he did with me recently. Pinal is the founder...
2009-08-10
557 reads
Journey to trouble-shoot Error 5042 (cannot remove a file xxx because it is not empty)
I was working on a table partition management task yesterday. The table is partitioned on a datetime column, and each...
2009-08-10
8,871 reads
Networking for Your Career
It's hard to actually put a specific value on networking, and I've been skeptical of it in the past. However...
2009-08-10
1,193 reads
Notes on SQLSaturday #16
I went down to Miramar Fri morning, taking the loooong drive from Sarasota across Alligator Alley on I-75. Miles of...
2009-08-10
482 reads
Social Networking: Where Do I Start?
In a blog post a few weeks ago, I wrote about social networking in the SQL Server community. I was...
2009-08-10
995 reads
What's new in Sql server 2008
Hi...Finally... the Complete Enterprise product sql server 2008 is a great product, it has everything includes features which other competitors...
2009-08-10
897 reads
Why Use Named Pipes?
The other day a colleague and I were shadowing a vendor who was installing their 3rd party application on a...
2009-08-10
24,190 reads
Microsoft Thrive
I was introduced to the Thrive program when my user group held a Thrive event back in March. Since then...
2009-08-09
544 reads
Blogs
The CDO’s Playbook for AI Driven Decision Making
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
sp_snapshot – The easy way to take database snapshots of one or more databases – V3.0
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
SELECT *
SELECT * feels convenient, but in SQL Server it bloats I/O, burns network bandwidth,...
Forums
combining a param value with widcards in a foreach loop files property
Hi, it isnt clear from the web if something like this should work as...
Extract sql data in psh
# Load ImportExcel module Import-Module ImportExcel -ErrorAction Stop # File paths $outFile = "C:\Reports\SQLReport.xlsx"...
caught off guard by some greek lettering in a warehouse feed
Hi we run 2019 standard. Our warehouse's ssis based etl is klunky but so...
Question of the Day
Vector Datatype
The new Vector datatype in SQL Server 2025 is a binary type that has a few parameters. What parameters are required?
See possible answers