SQLPeople: An Interview With Andy Leonard
The thing that I most enjoy about going to conferences, SQLSaturdays, and user group meetings is the people I get...
2011-03-14
1,689 reads
Blog Posts
SSRS: Shared DataSet, Not So Shared!!!
I was really excited about the concept of Shared DataSets when they were introduced. My excitement diminished a little when...
2011-03-14
5,724 reads
Stored Procedure Definitions and Permissions
I wrote a post a while back that showed how you can grant execute permission ‘carte blanche’ for a database...
2011-03-14
2,790 reads
The Lighter Side of Technical Interview Questions
I hate those puzzle type interview questions. I am sure that they show some level of aptitude about something, but...
2011-03-14
1,018 reads
March PASSMN Meeting This Week
I mentioned the PASSMN meeting last week and thought a reminder might be worthwhile. Just in case you head has...
2011-03-13
591 reads
SQLPSX 2.3.2.1 Release
We’ve released a minor update to SQLPSX which includes includes several bug fixes/enhancements as well as one new module. Here’s...
2011-03-13
1,039 reads
Do you know SqlServer ? Do you want an iPad ?
If you’ve answered yes to both of those questions , Jacob Sebastian has some more question for you.
Every day in March...
2011-03-12
540 reads
INDEX DEFRAGMENTATION SCRIPT for SQL server 2000
Advertisements
INDEX DEFRAGMENTATION SCRIPT SQL 2000
Index Defragmentation is one of the most important DBA tasks. This will significantly improve query performance....
2011-03-12
1,890 reads
Table-Valued parameters in SQL Server 2008
Introduction
The
most awaited feature has arrived - "Table-Valued parameters in SQL Server
2008". Here, I would discuss on how to use this new...
2011-03-12
4,529 reads
A Small Collection of SQL Azure Queries
We have been doing some more work with SQL Azure lately, so I have put together a small collection of...
2011-03-11
2,554 reads
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