2010-04-01 (first published: 2010-03-31)
4,378 reads
Additional Articles
Insider Insights
Insider rumours and gossip from the murky world of the Database Industry, and from the colourful characters that inhabit it.
2010-04-01
2,611 reads
SQL Server 2008 - Accessing Audit Details
Learn how to use the SQL Server 2008 catalog view and dynamic management view to access the audit details of existing server and database level audits.
2010-03-31
2,478 reads
A High Level Comparison Between Oracle and SQL Server - Part III
Part III of the Oracle / SQL Server comparison looks at the configuration options for each database, their storage options as well as the startup and shutdown procedures.
2010-03-30
4,344 reads
SQL Server Column Considerations and Column Placement
Determining which columns to select for your indexes is critical. Having a little knowledge of how your application is using your database columns and how SQL Server processes indexes helps you make good decisions when you create your indexes.
2010-03-29
3,850 reads
A High Level Comparison Between Oracle and SQL Server - Part II
Part II or the Oracle / SQL Server comparison dives deeper into databases by exploring the architectural differences.
2010-03-26
4,935 reads
A High Level Comparison Between Oracle and SQL Server
Part I of the Oracle / SQL Server comparison looks at the various editions of each database and their structure.
2010-03-25
6,514 reads
SQL Server - Introduction to Business Intelligence Development Studio
In his latest article, Marcin Policht demonstrates a variety of tools that can be employed to execute SQL Server Integration Services packages, focusing in particular on the method leveraging functionality available within the Business Intelligence Development Studio.
2010-03-24
3,539 reads
SQL Server 2008 R2 Multi-server Administration - A First Look
One of the most useful new features of SQL 2008 R2 for DBA’s is the ability to manage and administer multiple instances of SQL Server from a central location using the new SQL Server Utility tool.
2010-03-23
2,110 reads
Configure Windows Firewall for SQL Server 2008 Database Engine in Windows Server 2008 R2
I have installed SQL Server 2008 Developer Edition on Windows Server 2008 R2 and I am unable to get connect to SQL Server 2008 Instance from SQL Server 2008 Management Studio which is installed on another remote server. As I am new to Windows Server 2008 R2 it would be great if you can let me know the step by step approach to enable the default port of SQL Server 2008 in Windows Firewall for user connectivity.
2010-03-22
3,074 reads
Blogs
AI: Blog a Day – Day 6: Embeddings – How AI Understands
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
The Book of Redgate: Mistakes
By Steve Jones
This is kind of a funny page to look at. The next page has...
ADF Pipeline Debugging Fails with BadRequest – The Sequel
A while ago I blogged about a use case where a pipeline fails during...
Forums
Dynamic Unpivot
I have a table I didn't design that has tons of repeating groups in...
Writing as an Art and a Job
Comments posted to this topic are about the item Writing as an Art and...
String Similarity II
Comments posted to this topic are about the item String Similarity II
Question of the Day
String Similarity II
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers