SQL Rally Schedule
In case you didn’t see the email come through for PASS this week the SQL Rally schedule is now available. ...
2012-04-13
1,030 reads
Blog Posts
SSDT – Installation confusion
SQL Server Data Tools (SSDT) is a Business Intelligence Development Studio (BIDS) replacement, meaning it has a suite of Visual...
2012-04-13
11,512 reads
Table-Valued Parameter Example
I wanted show someone how to use table-valued parameters available in SQL Server 2008 and higher. The main use case...
2012-04-13
3,585 reads
A Strange Day at McDonalds
A few weeks ago I was running errands on a Saturday, with an almost final stop at Home Depot to...
2012-04-12
693 reads
April 2012 – Monthly SQL Server Checklist
Another month goes by and it’s time again to ask… are your SQL Servers healthy? Have they been properly configured? ...
2012-04-12
892 reads
Be Extra Careful When Packing
Over the last couple of years I’ve gotten myself down to two small, carry-on bags for most of my trips....
2012-04-12
1,092 reads
Microsoft Brings Back the Old Certification Acronyms MCSE and MCSA, starting with SQL Server
The new certification structure has been announced by Microsoft and the changes are rather broad and sweeping. MCITP is gone....
2012-04-12
1,959 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...
2012-04-12 (first published: 2012-04-09)
2,718 reads
Re-thinking security for customer service
This morning my son woke up to find his eBook reader frozen. It wouldn't unlock. It was fully charged (the...
2012-04-12
1,274 reads
Speaking at SQL Saturday #136 – Wellington, New Zealand
TweetG’day,
On Saturday 14th April I’ll be speaking at SQL Saturday 136 in Wellington, New Zealand.
My presentation is titled “Extended Events...
2012-04-12
990 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers