Trying to find the proverbial needle in the haystack of your SQL Server transactions is no small task. SQL Server Profiler not only helps you find that needle, it gives you details on all the other needles in a single interface.
2006-01-26
2,525 reads
The aggregate functions in SQL Server (min, max, sum, count, average, etc.) are great tools for reporting and business analysis. But sometimes, you need to tweak them just a little bit to get exactly the results you need. For example, if your manager came to you and asked for a report on how many sales have been made to your clients and how large they were, would you know how to get the data you need efficiently? Mark ran into something like this recently and here's the approach he took to solve the problem.
2006-01-25
3,507 reads
Haindong Ji brings us part 3 of his series on Oracle and SQL Server interoperability, this time taking a look at the Oracle Instant Client.
2006-01-24
12,070 reads
Database Snapshot (DB Snapshot for short) is a new tool offered by SQL Server 2005. Database snapshots can be used to protect against user errors, by creating a "snapshot" of your data that you can refer to later if you need to recover data or database objects that were accidentally (or even intentionally) updated or dropped. While the feature is quite useful, it doesn’t provide a 100% guarantee against user errors.
2006-01-24
2,078 reads
The new central tool for SQL Server 2005 is the SQL Server Management Studio and you can do most anything with it. Learn about this new utility and get a head start on SQL Server 2005 with a new book from SQLServerCentral.com by Dale Elizabeth Corey.
2006-01-23
23,413 reads
This example shows you how to cleanse data to look more modern in SSIS using the Script Component in transform-mode. It shows you how to make the first letter of every word capitalized from data that's in an unknown state.
2006-01-23
2,949 reads
Do you have a Web site or other system that deals in secrets of any sort? It seems like every time I give a security talk, people ask how to deal with the sticky problem of storing secrets. Connection strings with passwords are an obvious problem. You're better off simply using integrated security to get rid of those secrets, at least with SQL Server™, or an Oracle database. But what about credit card numbers and other financial or personal information? Can encryption help?
2006-01-23
2,476 reads
When considering business intelligence (BI) software, it is essential to be aware of underlying issues that can seriously impact on your bottom line. In a country where most businesses have information stored in several different databases, it’s no secret that the BI strategy you choose will effect your profit and loss target. From data collection and integration to data analysis, the holy grail of Business Intelligence software combines your disparate databases to provide a decision support system that will enable you to make key conclusions using all of the available information.
2006-01-20
2,455 reads
The guys that build software rarely get exposure of credit. Maybe that's why so many of them turn to open source where they get more well known. After a meeting at TechEd 2005, Andy Warren had the chance to get some interesting interview questions answered by Brooke Philpott, one of the 2 core developers of sqlSentry. And not a marketing guy.
2006-01-19
5,781 reads
This document describes the improved indexed views capability of SQL Server 2005 Enterprise Edition. Indexed views are explained and specific scenarios in which they may provide performance improvements are discussed.
2006-01-19
2,506 reads
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Comments posted to this topic are about the item Optimism Without Illusion or Why...
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Hi So the case statement is slowing this down - but for the life...
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers