My Schedule at the Summit/Let’s Connect
I’m flying out Sunday via Alaska Air, taking the direct flight from Orlando to Seattle, arriving at 11:40 am. If...
2009-10-30
1,200 reads
Articles
Using Information Schema Views
Many seasoned database developers tuck away all the commonly-used INFORMATION_SCHEMA queries as templates. They're an indispensable supplement to sp_help and sp_helpText to get handy information about your database objects, and, even if you use SQL Prompt, they're usually the best standard way to access such information programmatically within a routine. They are ISO standard SQL and are here to stay. Rob Sheldon goes through the basics in a timely refresher course.
2009-10-30
2,944 reads
Where Will We PASS Each Other?
In my a post on Monday, I talked about who I want to meet while at the PASS Summit. Today...
2009-10-30
1,205 reads
The 2009 SQLServerCentral party at the PASS Summit
Get some details about the 2009 SQLServerCentral party at the PASS Summit in November.
2009-10-29 (first published: 2009-07-20)
2,195 reads
Backup SQL Server Databases with a Windows PowerShell Script
In a previous tip on Backup and Restore SQL Server databases programmatically with SMO, you've seen how you can use Windows PowerShell to backup and restore SQL Server databases. In this tip, I will cover how to use Windows PowerShell to generate SQL Server backups
2009-10-29
3,690 reads
XY (Scatter) Chart for Analysis Services Data
Display data series' as a set of points with an XY (scatter) chart - typically to compare distinct values across categories. BI Architect Bill Pearson leads the hands-on creation of an XY chart based upon an Analysis Service data source.
2009-10-29
2,209 reads
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,999 reads
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
630 reads
Blogs
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
Forums
ALAMAT KONTAK BCA KCP Pecatu Telp:08218154393
WA:08218154393 nomor 275 Blok 4, Jl. Raya Uluwatu dan 5 No.99, Ungasan, Kec. Kuta...
ALAMAT KONTAK BCA KCP Ubud Telp:08218154393
WA:08218154393 Jl. Raya Ubud No.10, Petulu, Kecamatan Ubud, Kabupaten Gianyar, Bali 80571
ALAMAT KONTAK BCA KCP Benoa Telp:08218154393
WA:08218154393 Jl. Suwung Batan Kendal No.2, Sesetan, Denpasar Selatan, Kota Denpasar, Bali 80222
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers