Join Red Gate for a free seminar on September 27 (the day before SQL Saturday Denver). Steve Jones, SQL Server MVP and editor-in-chief of SQLServerCentral.com, will present best practices for SQL Server database development, in addition to showing Red Gate tools in action.
2013-08-20
1,406 reads
This article shows how to implement a Slowly Changing Facts Table, how to overcome the problems encountered when using the MERGE statement to process the data and suggest a minimal set of indexes to aid data loading and quering.
2013-08-19
10,207 reads
It’s hard to avoid privacy-based stories at the moment, with growing concern over government snooping and the limits of power. But where I’m based, in the UK, there’s a new, fully-privatised invasion of privacy. One marketing company has created an outdoor wi-fi basestation that grabs your phone’s MAC address as you pass, with the idea […]
2013-08-19
81 reads
How much of an improvement in processing time can a simple SQL Server Analysis Services (SSAS) partitioning structure provide? Can you provide any examples? Does this processing time improvement only apply to the fact tables? Check out this tip to learn more.
2013-08-19
4,512 reads
Though the Key/Value pair paradigm is common to almost every computer language, there is no clear agreement yet for the definition of a Key/Value Pair database. However, Key/Value pair databases are valuable for special applications where speed of writing data is more important than searching and general versatility. Buck Woody experiments.
2013-08-16
3,457 reads
This article describes different methods for deploying your SSIS projects to a server.
2013-08-15
10,079 reads
I’ve introduced my manager to SQL Server’s cloud based platform, SQL Azure and Windows Azure Virtual Machine. He wants to test functionality with some of our applications, which would require me to move my on premise databases to the Azure Virtual Machine. What is the easiest way to accomplish this task? See how it is done in this tip.
2013-08-15
2,928 reads
The SQLServerCentral.com survey will end on Wednesday August 21st. Let us know how we're doing and be in with a chance to win a $100 Amazon gift card. Winners will be announced later that week.
2013-08-15
2,625 reads
In this article Greg Larson outlines the exciting new features that come along with SQL Server 2014. He'll also let you know where you can download CTP1, as well as where you can find additional resources related to SQL Server 2014.
2013-08-14
4,381 reads
Specialized tasks like cryptography require external libraries that are not available in SQL Server. Methods for such tasks can be compiled in a .NET language and deployed to SQL Server as a CLR assembly where the assembly's methods can be referenced by SQL Server stored procedures and functions.
2013-08-13
9,119 reads
By Arun Sirpal
Claude is more than a chat window. The desktop experience includes structured workspaces, generated...
A sequential scan is not always a problem — PostgreSQL's planner often chooses one...
I’ve been thinking a lot lately about what it actually takes to make an...
Good Morning. I have a T-SQL Script which has been developed to execute a...
Comments posted to this topic are about the item Stop Prompting Your AI Agent....
Comments posted to this topic are about the item Finish the quote
Finish this quote (for a fun Memorial Day question):
Do not try and bend the spoon. That's impossible. ...See possible answers