Steve Jones takes a moment to talk about the SQLServerCentral.com reception at the Summit last week. And a few pictures as well. Whether you were there or not, see what you missed and what you can look forward to next year.
2005-10-06
4,275 reads
That certainly is a mouthful, but it boils down to author Michael Coles implementation of a sound matching search for SQL Server 2005. Another mouthful, but if you are interested in getting close matches because your clients cannot spell, you might want to read this one.
2005-10-05
21,153 reads
Throughout this and other of my series, we have examined parameterization and parameter picklist support. While my focus has often been support of picklists using datasets generated through MDX queries against the cube under consideration, I have often found myself in client engagement scenarios where differing reporting requirements, as well as various "exceptions," drive a need to extend picklist support beyond the capabilities of the basic MDX queries that we have examined.
2005-10-05
2,506 reads
Auditing SQL Server, or any system, is not an easy task and with new regulations like Sarbanes-Oxley, it is becoming a full time job in some environments. Chad Miller brings us a way that he developed with Excel and some scripting to automate some of the security information for a large installation of SQL Servers.
2005-10-04
11,361 reads
When most DW designers begin developing a data warehouse, the Time dimension is the first dimension reviewed with the users. There are usually two or three different persectives on what the Time dimension should represent but, for the most part, it will be used for such calculations as Year-to-date Sales, Monthly Inventory Churn, etc. What most users are actually describing is a Date, or Calendar dimension.
2005-10-04
2,698 reads
As your SQL Server applications grow, chances are that you have more and more objects, especially stored procedures that you need to keep track of. An organized environment is key to being able to prevent the duplication of code and effort. Joe Sack brings us a look at how he names stored procedures to easy identification.
2005-10-03
25,485 reads
Debugging is an important process for any level of programming to ensure programs function as expected. Most productive developer environments provide tools and utilities to assist with the debugging process. Visual Studio.NET 2005 is equipped with a number of debugger visualizers, but users can also create their own based on an individual project.
2005-10-03
2,280 reads
Do you know the difference between a login and a user? What's the best way to add them; Enterprise Manager, T-SQL, or SQL-DMO? In this beginner level article Andy demonstrates how to use all three methods to add logins and users and offers his view of which is the best technique.
2005-09-30 (first published: 2003-02-19)
37,506 reads
This tip continues the system stored procedure series with a routine to find occurrences of a string in the character columns of selected tables.
2005-09-30
3,781 reads
SQL Server has the best client tools for a DBA of any RDBMS and SQL Server 2000 includes Query Analyzer, an amazing tool. There are a few places where this tool could use some improvement and Yakov Shlafman brings us a few ways that you make your work with Query Analyzer even smoother.
2005-09-29
16,270 reads
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
By ChrisJenkins
Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
hi , a new user wants to be able to add sql agent jobs...
WA:08218154393 Jl. Dr. Saharjo No.149 G-H, RT.5/RW.4, Manggarai Sel., Kec. Tebet, Kota Jakarta Selatan,...
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers