TDS Endpoints: SQL Server’s “Listener”
In the land of Oracle, if you want to prevent user access to your database, you stop the listener. Without...
2012-04-17
1,750 reads
Colleen M. Morrow
So I started this blog…now what?
Date: May 19, 2012
Location: SQLSaturday #119, Chicago
Abstract:
Ever thought about trying your hand at blogging? Or maybe you’ve started a blog...
2012-04-14
563 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
954 reads
Slacking Off: Planes, Trains, and Automobiles
It’s finally Friday. Grab a cup of coffee, a breakfast pastry of choice, and take a break with some non-SQL...
2012-04-06
792 reads
What’s stopping you?
I mentioned earlier this week that I’m working on a new presentation for SQLSaturday #119 next month. The talk revolves...
2012-04-04
527 reads
Backup script skipping databases – and the fix!
A real head-scratcher
I’ve been using my RYO Maintenance scripts for a little while now, and they’ve been working great. Almost....
2012-04-02 (first published: 2012-03-26)
1,933 reads
Goals – 9 month checkup
Nine months down, three to go*. It’s time once again to see where I’m at with the goals I set...
2012-04-02
963 reads
RYO Maintenance Plan – History Cleanup
The last step in our campaign to rid the world of maintenance plans deals with housekeeping: the history cleanup step....
2012-03-22
975 reads
RYO Maintenance Plan – Integrity Checks
Happy Monday! Everyone fully recovered from St. Patrick’s Day? Hopefully the weather where you are was as perfect as it...
2012-03-19
874 reads
T-SQL Tuesday #028 – Jack of All Trades, Master of None?
Every month the folks of the SQL Server community get together for a virtual block party of sorts called T-SQL...
2012-03-13
684 reads
Blogs
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file...
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Compare rows within the same table
I have a table. Structure in script below. I have to compare and see...
Microsoft Recommendations for Update Stats?
I have an application team that is insisting on daily (and for some, weekly)...
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers