In continuing with our series of tips on Best Practices for SQL Server I'm turning my sights on Maintenance. Specifically in this tip we will be discussing Index maintenance: when, if, why, and how are questions that will be addressed.
2009-10-09
6,894 reads
Reporting Services is a great tool for presenting data to users. However the changes in SSRS 2008 might cause you a problem after installation. New author Patrick LeBlanc has a solution you can try.
2009-10-08
8,608 reads
Hadoop is an interesting new software project in the Linux world that deals with large data sets. Steve Jones wonders if anyone in the SQL Server world has started working with it.
2009-10-08
804 reads
Hadoop is an interesting new software project in the Linux world that deals with large data sets. Steve Jones wonders if anyone in the SQL Server world has started working with it.
2009-10-08
1,058 reads
Hadoop is an interesting new software project in the Linux world that deals with large data sets. Steve Jones wonders if anyone in the SQL Server world has started working with it.
2009-10-08
825 reads
In this tip I will show you an easy way to identify the scheduled Reporting Services report, so you can run that scheduled job to reproduce the reports and delivery of the reports.
2009-10-08
3,640 reads
In today's database reporting market, most vendor applications use a proprietary format for representing the definition of a report. In addition, vendors that provide a report execution environment usually only support their own design tools. For customers, this means that reports cannot be easily moved between different reporting implementations and that there are few options for choosing new tools that work with their existing execution environments.
2009-10-08
440 reads
Another frequently heard story is that stored procedures get and reuse execution plans, but ad hoc queries do not. A...
2009-10-07
3,203 reads
It's easy to get excited if you work at a startup, or a software company. But for corporate workers that toil in IT departments all around the world, how do you keep them motivated? Steve Jones has a few thoughts about simple things that make workers feel better about their jobs.
2009-10-07
491 reads
It's easy to get excited if you work at a startup, or a software company. But for corporate workers that toil in IT departments all around the world, how do you keep them motivated? Steve Jones has a few thoughts about simple things that make workers feel better about their jobs.
2009-10-07
469 reads
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
By John
Today is Christmas and while I do not expect anybody to actual be reading...
The state-of-the-art FARE Labs Environmental Testing Laboratory provides a broad range of testing services...
Comments posted to this topic are about the item Database security permissions save script
I have a SQL Agent job for backing up a set of Analysis Services...
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