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
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
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
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
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
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
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
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
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
Happy Monday! Everyone fully recovered from St. Patrick’s Day? Hopefully the weather where you are was as perfect as it...
2012-03-19
873 reads
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
By Arun Sirpal
I speak to many people who use cloud technologies, especially database tech and how...
I need to migrate from a single server to a flex server. Instead of...
By Steve Jones
An interesting AI experiment here with Copilot from GitHub in handling some code I...
Hi all We have setup History Cleanup tasks at clients to clear Maintenance plan...
Hey everyone! 👋 I’m currently researching the best healthcare app development companies based in...
Hello , Consider the following - much simplified - example of a conditional insert:...
What happens with this code:
DECLARE @Iteration INT = 0; WHILE @Iteration < 10 SELECT CustomerName, CustomerStatus FROM dbo.Customer WHERE CustomerID > 3; SET @Iteration += 1;See possible answers