Growing interest in analytics and the trend toward automated decision making will lead the business intelligence crowd toward the mix of mathematical and statistical techniques used by operations researchers.
Steve Jones looks at the performance of column changes, petaflop computing, and a few ways to beef up your DBA skills.
In this article I will try to address some of the design suggestions and experiences that I had in managing similar database.
A look at this book from James Wightman and Apress on the ETL subsystem in SQL Server.
How can you find good employees? Steve Jones offers a few tips on what has worked for him in the past.
Tracking changes to your development environments is important to ensure that your deployments to production go smoothly. Jacob Sebastion brings us a look at how well the Visual Studio Team System Edition for Database Professionals can help you with this task.
I have heard that Full Text Search uses a noise words to eliminate meaningless words in searches. I have also heard that a thesaurus is used, but I am not exactly sure how. Can you provide some details related to how both of these technologies are used in Full Text Search? I am interested in more of a background on these specific Full Text Search technologies as well as where the files are located and how I can update them.
Do the people that build SQL Server really work with it? Steve Jones shares a short story from a recent trip to the Pacific Northwest.
Do the people that build SQL Server really work with it? Steve Jones shares a short story from a recent trip to the Pacific Northwest.
Do the people that build SQL Server really work with it? Steve Jones shares a short story from a recent trip to the Pacific Northwest.
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
Comments posted to this topic are about the item The day-to-day pressures of a...
Comments posted to this topic are about the item The Problem Isn't Always Your...
Comments posted to this topic are about the item Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers