DBA.Sleep(8hrs)
I have been pondering recently what helps me to sleep at night. Or, conversely, what prevents me from sleeping at...
2010-02-18
1,609 reads
Articles
Striping SQL Server Database Backups
As databases get larger, the time for database backups to complete grows as well. Unfortunately, the time window for your backups may not increase. It could very well be the case that you reach a point where your backups will not finish in a specified amount of time.
2010-02-18
2,791 reads
Import Excel Spreadsheet to Database Tables
Importing Excel Spreadsheets is something that we often do with SQL Server. However it's not as easy as you would like as we move to the 64 bit platform. Peter He brings us a method that will work on all platforms.
2010-02-17
20,652 reads
Database Level Auditing with Microsoft SQL Server 2008
MAK shows us how easy it is to create a database level audit, test the audit and retrieve the audit records in Microsoft SQL Server 2008.
2010-02-17
5,905 reads
Managing Analysis Services Deployment - Part 1
In part 1 of this series, Shahfaisal Muhammed brings us one method of deploying your SSAS projects to a new server. The rest of the series will cover other methods.
2010-02-16
8,594 reads
Professional Microsoft SQL Server Analysis Services 2008 with MDX - Sample Chapter
A sample chapter from a new book on Analysis Services. Check it out and see if this is the book for you.
2010-02-16
2,086 reads
Webinar Series: SQL Server 101
A partnership with Pragmatic Works brings you some basic SQL Server training through a series of webinars.
2010-02-15
2,075 reads
2010-02-15
15,128 reads
Use SSIS to import one cell of an Excel file into SQL Server
Recently I needed to find a method to import one cell of an Excel sheet into SQL Server 2005 using a scheduled job on a 64 bit clustered environment. For example, I have a monthly sales report listing sales per product category, such as Books, Magazines, DVDs, etc. I only want to import the Total Sales amount into SQL Server and this number is located in an Excel file "sales.xls.sheet1.cell.B5". I used to use OPENROWSET to solve the problem, however OPENROWSET requires Microsoft Jet OLE DB Provider which is not available in 64 bit. In this tip I am going to talk about how to use SSIS to accomplish this task easily.
2010-02-15
4,402 reads
Tips for New DBAs
New and old DBAs alike can benefit from going back to the roots of the profession. This series of articles highlight the skills needed to move to the next level of Database Administration.
2010-02-12 (first published: 2008-11-18)
46,327 reads
Blogs
SQL Server 2016 Has Reached End of Support. Now What?
By SQLPals
SQL Server 2016 Has Reached End of Support. Now What? On...
The New Unified Copilot in Fabric and Project Osmos: From AI Assistance to Agentic Data Engineering
By James Serra
(This post starts a three-part series on how AI is changing the way we...
SQL Server Problems You Can Reproduce, Measure and Fix: A Free Demo Library
I built a free library of runnable SQL Server demos. Each reproduces a real...
Forums
Alamat Telp BCA KCP Kramat Jati +62 838-4945-0961
Wa:083849450961 Jl. Raya Bogor No.19, RT.1/RW.4, Wil, Kec. Kramat jati, Kota Jakarta Timur, Daerah...
Alamat Telp BCA KCP Modernland +62 838-4945-0961
Wa:083849450961 Ruko Modern Walk, Jl. Hartono Raya No.063 MW No. 062, RT.001/RW.006, Klp. Indah,...
Hyperscale Replicas V
Comments posted to this topic are about the item Hyperscale Replicas V
Question of the Day
Hyperscale Replicas V
I have an Azure SQL Database Hyperscale Edition system running with a geo-replica enabled. Can I create a new geo-replica based on the current secondary geo-replica?
See possible answers