Have you ever needed to find something in a stored procedure or function and found yourself trying to wade through syscomments? Ever want to know which views reference a table, but you don't trust sysdepends? BDS has released SQL Digger 2.0, a utility designed to help you search through your schema and code to find what you need.
2005-04-05
3,824 reads
SQL Server 2000 DTS was a revolutionary programming environment, but one that was not without a few quirks. As often found with many Microsoft products, there were sections in your packages where things were hard coded, making them less flexible. New author Jeremy Brown brings us a look at how you can build extremely flexible packages using Perl.
2005-04-05
11,060 reads
In the first of a three-part series, learn how to use XML maps to customize Excel as a data input and display system.
2005-04-05
1,643 reads
Or at least the types of your data. New author Roy Carlson was working in SQL Server 2000 to calculate some values based on row counts, sales amounts, etc. and discovered some interesting results. Without his sharp eye, a number of individuals would have been upset by the resulting lack of commissions, as may some of your clients. Read about some potential problems in your calculations if you are not careful with your data types.
2005-04-04
6,675 reads
With it's VizQL, Tableau Software is revolutionizing the way that you will analyze data. Built to work with multiple data sources, including SQL Server databases and Analysis Services cubes, this software will amaze you.
2005-04-04
3,536 reads
Gain a better understanding of how to develop your SQL Server Mobile applications to handle multi-user access and data synchronization with Microsoft SQL Server 2005.
2005-04-04
2,112 reads
Microsoft Corporation has announced plans to acquire the
Website and Internet development corporation Higher Source for an
undisclosed fee.
2005-04-01
2,383 reads
Are you looking for a head start on learning about SQL Server 2005? Able to get to Reading in the UK in May? One of the premier SQL Server MVPs, Itzik Ben Gan, is teaching a full day seminar on Advanced T-SQL, covering both SQL Server 2000 and 2005 on May 3rd.
2005-03-31
5,673 reads
In working with many reporting tools over my career, particularly within enterprise business intelligence suites and high-end production reporting systems, I have become acquainted with various control features in each that allow administrators to govern the actions of end users. Reporting Services is no different in this aspect of need for control, and the application provides numerous avenues for restraining our users from kicking off resource crippling queries that, unchecked, could disrupt even the most robust systems, as well as to prevent other harmful activities. At various junctures within this series, we will examine ways to effect such controls on an intermittent basis.
2005-03-31
2,850 reads
Maintaining control of your schema with SQL Server 2000 can be cumbersome. However there are starting to be more and more tools to assist you with version control and tracking your schema over time. Nob Hill software has a tool that helps, which is currently in Beta and code named "Randolph". If you have a need, check out their new product.
2005-03-30
2,663 reads
Here’s the scenario: one of my SQL Server instances migrated to the DR array....
By Steve Jones
We are product focused at Redgate Software. Here is another of our values that...
By Zikato
A fugitive cyber-criminal, a wingsuit, and 24 million flight records. Somewhere between Doha and...
hi, a few years ago was at a very large company that bought a...
Comments posted to this topic are about the item Implicit Conversions Cripple SQL Server
Comments posted to this topic are about the item BIT_COUNT() III
In SQL Server 2025, I run this code:
select bit_count(-1)What is returned? See possible answers