Index Primer - Just what statistics are kept?
An in-depth look at index statistics and how they are used by the optimizer by Josef Richberg.
2009-10-28
7,989 reads
Articles
A Unified Approach to Multi-DataBase Query Templates
While trying to get the information he needed out of various SQL, MySQL and Oracle environments, Michael finally got tired of endlessly flicking through reference manuals and having to work so hard just to formulate his queries. So he decided to build a cross-platform Query Template solution to make his life easier, and he even went as far as building a .NET control to be integrated into applications. He's been kind enough to share the control, and the theory behind it, with us.
2009-10-28
1,971 reads
Introducing Microsoft’s Platform for Complex Event Processing
While typical relational database applications are query-driven, event-driven applications have become increasingly important. Event-driven applications are characterized by high event data rates, continuous queries, and millisecond latency requirements that make it impractical to persist the data in a relational database for processing. These requirements are shared by vertical markets such as manufacturing, oil and gas, utilities, financial services, health care, web analytics, and IT and data center monitoring. Event-driven applications use complex event processing (CEP) technology with the goal of identifying meaningful patterns, relationships and data abstractions from among seemingly unrelated events and trigger immediate response actions.
2009-10-28
2,185 reads
Sharepoint Growth is Good
Sharepoint is a product that many IT people despise, but it's a popular seller for Microsoft. Steve Jones thinks that Sharepoint's growth is a good thing for DBAs as well.
2009-10-28
655 reads
Sharepoint Growth is Good
Sharepoint is a product that many IT people despise, but it's a popular seller for Microsoft. Steve Jones thinks that Sharepoint's growth is a good thing for DBAs as well.
2009-10-28
630 reads
Sharepoint Growth is Good
Sharepoint is a product that many IT people despise, but it's a popular seller for Microsoft. Steve Jones thinks that Sharepoint's growth is a good thing for DBAs as well.
2009-10-28
619 reads
A Neural Network in SQL Server
Modeling and programming a neural Network in SQL Server from new author Silvia Cobialca. Learn how you might be able to implement this AI construct in SQL Server to make predictions.
2009-10-27
12,409 reads
How to identify when a database was restored, the source of the backup and the date of the backup
After restoring a database your users will typically run some queries to verify the data is as expected. However, there are times when your users may question whether the restore was done using the correct backup file. In this tip I will show you how you can identify the file(s) that was used for the restore, when the backup actually occured and when the database was restored.
2009-10-27
4,162 reads
PASS Update #18
Eric Wisdahl posted some questions on my last update, and I thought I’d reply here to make my answers more...
2009-10-27
1,051 reads
TechNet Magazine - Oct Q&A
Unexpected Consistency Checks, Troubleshooting Memory Usage, More from Paul Randal.
2009-10-27
2,044 reads
Blogs
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Forums
SQL Server 2019 - Agent job PowerShell step issue
I have a couple of SQL Agent job steps which run PowerShell commands of...
Database security permissions save script
Comments posted to this topic are about the item Database security permissions save script
Database backup job steps
I have a SQL Agent job for backing up a set of Analysis Services...
Question of the Day
The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers