There is a new data type in SQL Server 2008 that might help you deal with all those music, image, and other media files in SQL Server. FILESTREAM allows you to store these files in the file system, but access them from within SQL Server. New author Deepa Gheewala brings us a look at setting a table for FILESTREAM.
Is it possible to change the default directory for backups, so it does not need to be specified each time I run a backup?
It is a simple routine that we all need to use occasionally; parsing a delimited list of strings in TSQL. In a perfect relational world, it isn't necessary, but real-world data often comes in a form that requires one of the surprising variety of routines that Anith Sen describes, along with sage advice about their use.
The myth of Prometheus has some relevance to technology workers. How? Read what Steve Jones thinks.
The myth of Prometheus has some relevance to technology workers. How? Read what Steve Jones thinks.
The myth of Prometheus has some relevance to technology workers. How? Read what Steve Jones thinks.
This video shows how you can use Management Studio to execute your Integration Services packages.
Books online mentions that performance may be reduced when using database snapshots. I decided to investigate how severe that reduction could be.
Steve Jones isn't talking about his new television, but rather a new technology dealing with data and databases.
Steve Jones isn't talking about his new television, but rather a new technology dealing with data and databases.
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forgive me for the title. Mentally I’m 12. When I started my current day...
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Comments posted to this topic are about the item Expanding into Print
Comments posted to this topic are about the item Downtime Caused by the Postgres...
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers