Remember the Milk: Smart Adds
A while ago, Brent Ozar pointed me to Remember the Milk to help with task tracking. It's a web-based task...
2009-09-08
1,004 reads
Blog Posts
Replication troubleshooting.
Hi All,Continue on Transaction replication discussion: Today I would like to share some of the important ways of handling/troubleshooting replication...
2009-09-08
673 reads
Smarter Intellisense
Intellisense is one of my favorite features in SQL Server Management Studio and BIDS for 2008. A common frustration I...
2009-09-08
978 reads
SpeakerRate – Need Your Feedback
Everybody loves a compliment. Not everyone enjoys criticism, even if it’s constructive and politely delivered, but the fact is that...
2009-09-08
771 reads
Star Join Optimization in SQL Server 2008
When working with a dimensionally modeled data warehouse it is common for a large number of your queries to follow...
2009-09-08
6,205 reads
Transaction replication info
Hi,To continue with the replication discussion, on my last post i discussed on some important commands and sp's for how...
2009-09-08
737 reads
Windows 7, UAC, and SQL Server
This is just a quick note, almost a continuation of my Access Denied, Not Possible post. I have been working...
2009-09-08
377 reads
Expense Reporting
I got a $25 app card with my iTouch, and forgot about it. However when we had guests over last...
2009-09-07
476 reads
MIF Busters
Management Information Format (MIF) files are formatted text files containing additional information about hardware and software components. The MIF format originated...
2009-09-07
1,600 reads
Running with more permissions
Recently someone was asking how they could execute some ALTER DATABASE commands without requiring sysadmin permissions. This person's company didn't...
2009-09-07
357 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Forums
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers