SQL Server Performance Tuning with Hypothetical Indexes
Daniel Farina demonstrates how to create and test hypothetical indexes with the undocumented DBCC AUTOPILOT command.
2014-06-13
3,858 reads
Tips and tricks
How to hot-add a vCPU to a virtual SQL Server
One of the benefits of running SQL on virtual environment is the capability to present additional vCPUs to the virtual server online and real-time without interruption to running processes. Our VM administrator normally presents only 1 vCPU on the virtual server and extends as required. This article describes how SQL Server is able to detect hot-added vCPUs in my virtual server.
2013-10-18
2,865 reads
SQL Server Integration Services Connection Manager Tips and Tricks
In this article, we will take a look at the following Tips and Tricks for Connection Managers: Adding an "Application Name" property to the connection string; Creating Two Connection Managers for each Database Connection; and Capturing Connection Manager details in Package Configurations
2013-10-15
5,063 reads
SQL Server Reporting Services Tips and Tricks to Improve the End User Experience
In this article we'll take a look at the following Tips and Tricks for SSRS: Display Total Number of Pages while Navigating, Display Everything in a Single Page, Display Report Parameter Selection, Display No Rows Error Message, Page Settings for Optimal Printing.
2013-09-03
5,988 reads
SSRS Expressions Tips and Tricks
Some of the expressions and functions that have come in handy while developing reports in SSRS
2009-12-21
33,487 reads
2004-04-16
RE: Easier way to use a path
You can map a drive, just have to make sure it's mapped under the agent account.
2004-02-27
Easier way to use a path
Is there an easier way to refer to a path, such as:\\servername\f$\folder 1\folder 2\folder n\application.exeCan I somehow give this path a "logical" name so that I can refer to that, instead of the long path everytime I use it in a job ?I have a server that points to other servers via jobs (enterprise mgr) […]
2004-02-27
Online Resources
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-02-23
RE: Storing an Excel Sheet in an SQL field.
Ok, some thoughts about why you shouldn't put them in the DB. I will grant you this is a bit old school in thinking but it is something to consider. Why put something in a database -- You need to search on it -- You need to really control access and NTFS security is too […]
2003-06-23
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers