Top 5 reasons to run for the PASS Board of Directors
There have been quite a few posts in the SQL Server community recently announcing the Call for Nominations for the...
2009-08-27
471 reads
Blog Posts
Upcoming Microsoft Gadgets
Microsoft has finally officially announced the long rumored price cuts for the XBox 360 Elite, which will go down from...
2009-08-27
642 reads
Access Denied, Not Possible
What’s going on here?
When trying to open Default Trace files on Windows 7 and SQL Server 2008 I got the...
2009-08-26
1,201 reads
Application and Multi-Server Management With SQL Server 2008 R2
Microsoft has published a good whitepaper that explains the new functionality in SQL Server 2008 R2 that will allow you...
2009-08-26
586 reads
Building a Better Blog - Next week during the 24 hours of PASS
I've got a new presentation on blogging slated for next week during the 24 hours of PASS. The event is...
2009-08-26
813 reads
Corruption in sys.dependencies
The second type of corruption I want to look at is that of missing references in sys.sql_dependencies. This typically appears...
2009-08-26
429 reads
Error Importing DTS package in SQL Server 2008
Opening DTS packages on a 2008 SQL Server requires several steps to be able to view the packages in a...
2009-08-26
1,579 reads
Intel Calpella Launch At End of September?
According to Gizmodo, Intel is due to launch the next generation Centrino mobile platform, known as Calpella at the end...
2009-08-26
581 reads
Microsoft SQL Server 2008 Books Online (July 2009)
Microsoft has released the July 2009 standalone version of Books Online (BOL) for SQL Server 2008, which you can get...
2009-08-26
659 reads
PASS Call for Nominations
The call for nominations for the PASS Board of Directors is open until Sep 3rd and I want to reiterate...
2009-08-26
1,277 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
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...
Unlocking High-Concurrency Inserts in SQL Server with OPTIMIZE_FOR_SEQUENTIAL_KEY
Comments posted to this topic are about the item Unlocking High-Concurrency Inserts in SQL...
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