Nifty queries using a Numbers helper table
(The complete usable code is in the very bottom of this blog post)
Some of you may have seen this “numbers...
2012-04-09 (first published: 2012-04-04)
4,633 reads
Blog Posts
Onward and Upward!
As you may have heard by now, I am joining the wonderful team at SQLskills as a Principal Consultant starting...
2012-04-09
1,008 reads
Quick Reference: How Do I Read an Excel XSLM (Macro-Enabled) File in SSIS?
Excel 2010 (and presumably the next version of Excel) have taken some security precautions with regards to macros in Excel files. If a spreadsheet has macros in it, you...
2012-04-09
208 reads
SQL Azure Saturday, WIT NYC and other local events!
Good day! Just wanted to share some exciting upcoming local events in the NYC/NJ area.
Hosted by the NJ SQL User...
2012-04-09
1,228 reads
SQL Saturday #107 in Houston, TX
SQL Saturday #107 in Houston, TX
Houston Skyline
SQL Saturday #107 in Houston, TX is almost here. I will be leaving for...
2012-04-09
1,610 reads
SQL Saturday #107–Houston
Wow, blessed to speaker at another SQL Saturday in Houston #107. The first task of this weekend is Friday. Kalen...
2012-04-09
726 reads
SQL server failed to start the system cannot find the path specified
AdvertisementsRecently one of our SQL server unable to start it. The problem with the storage LUNs.
Things you have to do:...
2012-04-09
6,241 reads
SSAS development quick tip
When creating a new cube in SSAS, you are frequently making changes that cause the whole cube to reprocess when...
2012-04-09
1,957 reads
SSIS How-To: Reuse Existing Connection Manager to Execute SQL in Script Task
There’s a myriad of examples out there on how to execute a sql task via OLEDB connections and C# in a...
2012-04-09
3,263 reads
Thoughts on Twitter
We hear a lot about social media these days: Facebook, LinkedIn, Google+, Twitter, etc. More and more, we’re expected to...
2012-04-09
960 reads
Blogs
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forums
Backup to Immutable Storage
Comments posted to this topic are about the item Backup to Immutable Storage
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Question of the Day
Backup to Immutable Storage
In SQL Server 2025, a backup can be made on Azure Immutable Storage. What changes in how the backup is created?
See possible answers