All Data Readers Are Evil
The DBA's Mantra: All data readers are evil. Steve Jones talks about a proposed corollary that might be appropriate to ensure security.
The DBA's Mantra: All data readers are evil. Steve Jones talks about a proposed corollary that might be appropriate to ensure security.
Greg Larsen looks at one way to design your database connection strategy to simplify changing application connections so you can plug-n-play databases with less administrative overhead when the need arises.
Along with some best practices, SQL Server MVP Hilary Cotter shares a log shipping setup process from start to finish.
How should we build tools? Should they be easy to use? Or does it make sense to have some things hard to do so that only experienced used choose them. Steve Jones comments on usability and the implications of your choices.
How should we build tools? Should they be easy to use? Or does it make sense to have some things hard to do so that only experienced used choose them. Steve Jones comments on usability and the implications of your choices.
In an interesting exercise in data conversion, Stephen Lasham brings us a nice article on basic manipulations.
SQL Server allows some interesting index behavior and there's been some debate over whether it makes sense or not. This Friday Steve Jones asks if you have a reason for this.
This white paper introduces Microsoft SQL Server developers to the international features of Microsoft SQL Server 2005. Topics covered include an explanation of Unicode, added support for supplementary characters in SQL Server 2005, the changes in collation in different versions of SQL Server, changes in data types, performance, updates on data providers, and new international support features in SQL Server 2005 Analysis Services and Integration Services.
In which Phil takes a break from a tedious bit of routine coding to build a Spam Filter in SQL.
By Steve Jones
On Thursday, May 2, we have the Redgate Seminar in Brisbane. I’ll be at...
By Brian Kelley
Microsoft Fabric is the new data offering in Microsoft Azure and there is a...
By Rohit Garg
In the expansive landscape of software development, the relationship between Database Administrators (DBAs) and...
I'm hoping someone here has encountered this before and was able to fix it....
Hi everyone, So I have a SSIS package that performs some importing/exporting from MySQL...
Hello SSC, I am not a DBA,. I have some DBA knowledge, but my...
In which editions of SQL Server 2022 can you run Reporting Services?
See possible answers