You are a database developer looking for a common approach for handling read and write access to binary files. You may be a DBA wanting to read various information from binary files and collect it into tables. The code sample presented in this tip will get you started with binary file content handling in SQL Server.
Platform as a service, a new way of looking at applications. It's analogous to SAAS and IAAS, which can improve the efficiency of the software purchase or the hardware acquisition process. Steve Jones notes that this is something he'd like to see for database platforms.
In part 2 of our best practices clinic, Brad McGehee looks at a couple of the items that were misconfigured on the SQLServerCentral database instances.
This article demonstrates how to prevent primary key violation issues in transactional replication.
Free training sessions brought to you by the AppDev and BI Virtual Chapters of PASS.
Some of our SQL Servers contain tables with summarized data (summarized on a weekly / monthly / quarterly basis). Previously this data was emailed as a flat file attachment to the recipients. I was asked to convert this in such a way that the email itself contains the table data. This way the recipients would be able to look at the data in a tabular format, making it easier for readability. Hence we arrived at the question of how to send email from SQL Server with data in a tabular format.
An interesting mystery on why some nHibernate performance issues might exist on your systems. Read this piece from SQL Server expert David Poole and look to see if this is a problem you can easily solve in your environment.
Quite a few utility companies and energy producers have ha data breeches in the last year, yet most of them don't have good tools to detect the intrusions or the support of executive management. Steve Jones talks about this being a problem in many companies.
Steve Jones talks about the possibility of SQL Injection, or other security issues from malformed input, affecting our lives in new and annoying ways.
For Day 7 of this series, I will talk about the incredibly useful CPU-Z utility, which is available for free...
In my previous post, I showed you how to build a snapshot backup catalog...
By Steve Jones
Train employees well enough that they could get another job but treat them well...
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
Comments posted to this topic are about the item Create an HTML Report on...
Comments posted to this topic are about the item Why Data Modelling Still Matters...
Hi when i think of server hops , i think of how kerberos assists...
When I run this code, how many rows are returned?
DECLARE @meals NVARCHAR(1000) = N'夕食昼食朝食' DECLARE @s NVARCHAR(1) = N'食' SELECT value FROM STRING_SPLIT(@meals, @s) GOSee possible answers