There is an urgent need to acknowledge the limitations of data models and find a way to bridge the logical-physical divide between models and actual databases so that database designs can be fully understood.
2007-09-13
3,221 reads
In this one I'll discuss some of the problems that can arise and how to troubleshoot them.
2007-09-12
2,853 reads
One of the things coming from our look at SQL Server 2008 Integration Services is that you are not going to see a lot of change visually. What you are going to see is things going on underneath the covers that makes SSIS perform better, and improved informational messages from the components. Just such a change is seen in the Script task.
2007-09-12
2,072 reads
We have a first look at one of the features in SQL Server 2008 that was cut from SQL Server 2005, but which has been highly anticipated. How many times have you written an "insert new, update match" routine? Jacob Sebastion shows us easy this becomes with the new MERGE keyword in SQL Server 2008.
2007-09-11
14,080 reads
EDM solutions are a logical and often necessary complement to operational analytics.
2007-09-11
1,296 reads
Learn how to set up delegation on your SQL Server instances, so you can use the impersonate options when setting up the security properties of linked server definitions.
2007-09-11
2,732 reads
Most experienced DBAs know that sysdepends is not very reliable, so how can you find the dependencies inside your database? New author Christian Buettner brings us his technique for finding those hidden dependencies based on your query plans.
2007-09-10
8,847 reads
This article shows how to retrieve both remote and local XML data and display it in a data Web control.
2007-09-10
4,105 reads
Simon Sabin is always cagey about giving advice on the sort of hardware to run SQL Server on, but admits to some general rules.
2007-09-10
4,327 reads
How many times have you wished that there was a parameter for DATEPART to allow you to check for workdays? While many of us may get stuck working 6 or 7 days a week, most of the world revolves on a 5 day work week. Monday through Friday. New author Jeff Moden brings us a method of easily calculating the number of workdays between any two dates.
2007-09-07 (first published: 2005-01-10)
74,862 reads
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Comments posted to this topic are about the item Moving Beyond the Reboot: Finding...
Comments posted to this topic are about the item Reserved Words I