Snagit…
If you read my last post, you may have noticed that my images now include boxes, balloon text and highlighting. ...
2010-03-21
565 reads
Blog Posts
A little restriction that prevent changing tables in SQL Server 2008
In SQL Server 2008, by default, the option to prevent tables changes is "on". We can have some issues and...
2010-03-20
2,821 reads
Determine which version of SQL Server is running...
Since the early versions of SQL Server, from version 6.5 we can know and
determine the latest version that we...
2010-03-20
1,078 reads
Random Thoughts on Aliasing
Here are many different thoughts/facts/preferences on aliasing. Most of this applies to column aliasing. Regardless of whether or not you...
2010-03-20
1,354 reads
Be Wary
We make mistakes when we publish things. It happens, and I am as guilty as some people of mistakenly putting...
2010-03-19
921 reads
Being Involved in the Community
Regular readers know that I enjoy being involved in the SQL Server community. Over the last two and a half...
2010-03-19
342 reads
Licensing SQL Server Reporting Services
I have my license here somewhere, officer.
Licensing models can sometimes make database modeling seem trivial. Per processor or per seat?...
2010-03-19
1,102 reads
Losing Two Days
I’m off tomorrow to the UK for a week of work at the Red Gate offices, and then a couple...
2010-03-19
656 reads
Security Audit
Of late I have seen a lot of questions on how to audit the logins and users on each SQL...
2010-03-19
1,781 reads
SQL Log Shipping – by Abi Chapagai
SQL Server 2008 High Availability Solution: Log Shipping
In SQL Server, transaction log provides an ability to recover a database...
2010-03-19
1,711 reads
Blogs
Monday Monitor Tips: The MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, and pressing on...
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Forums
Removing production permissions when restoring database to non-prod
Hello experts, An application team has asked us to modify a SQL Agent job....
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...
Finding Bad Queries
Comments posted to this topic are about the item Finding Bad Queries