Join MSAS Architect Bill Pearson in hands-on exercises, where we gain exposure to the use of the MEMBER_UNIQUE_NAME property in generating simple lists, as well as datasets to support report parameter picklists.
This Friday Steve Jones comments on the practice of using Active Directory to help manage your SQL Server and what the best practice should be.
This Friday Steve Jones comments on the practice of using Active Directory to help manage your SQL Server and what the best practice should be.
This Friday Steve Jones comments on the practice of using Active Directory to help manage your SQL Server and what the best practice should be.
A technical paper from the SQLCAT team on moving databases with service broker applications.
How quickly should you report a loss of data? It's an interesting question in these security conscious times and Steve Jones talks about
This article from Wayne Sheffield shows how the use of XML can speed up those string manipulations in your T-SQL code.
We are looking to automate some tasks to be performed on our SQL Server Analysis Services Servers. Can you give us the details on how the Analysis Services Execute DDL Task can be used in a SQL Server Integration Services (SSIS) package?
Some reasons for the slow-running of database applications aren't obvious. Occasionally, even the profiler won't tell you enough to remedy a problem, especially when a SQL Statement is being forced to wait. Now, in SQL Server 2008, come XEvents, which allow you to look at those waits that are slowing your SQL Statements. Mario Broodbakker continues his series about SQL Server Wait Events
SQL Know How is holding a 3 day seminar in Hatfield, Hertfordshire in the UK this September 1-3.
Reading tutorials is fine. Shipping something is better. If you are trying to break...
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Comments posted to this topic are about the item Liability for AI Errors
Hello , I would like to run a stored procedure on a secondary replica...
Comments posted to this topic are about the item Pro SQL Server Internals
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers