From this real-world case study, learn how you can boost SQL Server performance and scalability by off-loading reporting from your production SQL Server to a reporting server, using transactional replication.
Running short of disk space? One way to solve that is to keep fewer backups on disk, or write a routine that will compress them to conserve space. Or you could try SQLZip, an add in that creates compressed backups. Read the review, see if it's something you should consider!
As you advance in your skills as a Transact-SQL developer or SQL Server database administrator there will come a time when you need to override SQL Server's locking scheme and force a particular range of locks on a table. This article by Randy Dyess shows you how to optimize your queries using table hints.
"Certification mania" has hit IT, big-time. Many employers look for certification in potential employees and especially in IT contractors. If you're a data administrator or DBA, you have to consider: could DBA certification enhance my career? Would it deepen my knowledge and increase my value to my company?
This article demonstrates the ability to use the XML DOM on the client-side browser.
As I work with a particular topic or problem, I often research on the Internet different opinions, white papers, etc. Here is a list of resources that are located both on SQLServerCentral.com and other sites that I have found useful.
The core components to Microsoft XML parser have been updated and released to market. The update contains many bug fixes, new features and enhancements to performance.
Steve Jones continues his series on string manipulation. This articles examines the issues of quotes when implementing dynamic SQL.
By Steve Jones
I hosted this month, but I decided to put my own entry in as...
By Chris Yates
I get asked a lot about why or how I began working with databases...
By Steve Jones
Earlier this year I visited a customer that was using the Redgate Monitor webhook...
Comments posted to this topic are about the item Implementing PostgreSQL with Python for...
Comments posted to this topic are about the item Identify a Slipstream Installation
Comments posted to this topic are about the item Internal Staff Growth, which is...
I get a new SQL Server instance from my build team. How can I tell if the instance was installed using a slipstream installation later?
See possible answers