This white paper describes the FILESTREAM feature of SQL Server 2008, which allows storage of and efficient access to BLOB data using a combination of SQL Server 2008 and the NTFS file system. It covers choices for BLOB storage, configuring Windows and SQL Server for using FILESTREAM data, considerations for combining FILESTREAM with other features, and implementation details such as partitioning and performance.
When it comes to securing a system, it's important to understand how it might be attacked. That's what surface area is all about. The surface area is the parts of the system which are exposed. For instance, in the case of a default instance of...
Who do you blame when software fails? Hopefully you don't hire a lawyer before you do. Steve Jones talks about liability and software.
Who do you blame when software fails? Hopefully you don't hire a lawyer before you do. Steve Jones talks about liability and software.
Who do you blame when software fails? Hopefully you don't hire a lawyer before you do. Steve Jones talks about liability and software.
Building random numbers can be challenging for people working in T-SQL. New author Chris Nowicki brings a solution he used to get a random number assigned to each row of a result set.
Are user groups dying out in the age of the Internet? It seemed that way for awhile, but Brad McGehee gives some reasons why you should think about attending a meeting.
In this tip I am going to start my brief discussion with OPENQUERY and OPENROWSET table functions, its limitation and how the new EXEC AT command overcomes them.
When discussing the normalisation process, it is always the First Normal Form that causes the most grief and confusion. Anith Sen takes up the challenge to explain, in simple terms, exactly what the First Normal Form really is, and why it is so important for Database Design. Along the way, he dispels some of the myths that have grown up around 1NF.
Google is trying to figure out who might quit the company, using their own custom application. Steve Jones thinks this is a great idea and wishes more companies would do it.
By Brian Kelley
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...
No two SQL Server environments are alike. A fix that resolves a performance issue...
By ReviewMyDB
My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I...
A new thread for testing the spam filter. Adding a link: https://www.bbc.co.uk/weather
Hello experts, An application team has asked us to modify a SQL Agent job....
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...