Cloud Common Sense
Moving to the cloud, or any other type of outsourcing should be done with common sense, as Steve discusses today. That means keeping control of your backups.
Adding Custom Code to the Reporting Services 2008 R2
There are numerous circumstances when we wish to add a custom function to a SSRS report in order to cater for needs of the customer which exceeds the capability of the built-in functions in SSRS. In these scenarios we will have to write our own functions. In this article you will see how to add custom code to SSRS.
Architecture Career Paths for SQL Server Professionals
On Thursday September 15th, MCM Robert Davis will discuss the architect jobs and their meanings.
Jeff Moden elected Exceptional DBA of 2011
We are pleased to announce that Jeff Moden has been elected by judges and the SQL Server community as the Exceptional DBA of 2011.
Not on the Same Page
It seems that security staff and other technical people are not always on the same page. Steve Jones says that we should be working to take security more seriously.
Unique Indexes in SQL Server: Stairway to SQL Server Indexes Level 8
Indexes that ensure data integrity in addition to locating rows.
SQL Bits 9 - Query across the Mersey
Come join Steve Jones and many other SQL Server pros in Liverpool for SQLBits on Sept 29-Oct 1.
SQL Server Index Statistics
Are your index statistics up to date? The SQL Server database engine uses statistics to determine which execution plan to use when a query is compiled. Index statistics are used to help the SQL Server engine determine the cardinality of different column values in a SQL Server table. If you want to give SQL Server a fighting chance at picking an optimal execution plan then you need to make sure you maintain your index statistics.
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
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