Basic SQL Interview Questions
We decided to add blog post that covers only basic SQL Interview questions and answers. The blog currently provides only...
2012-07-07
1,068 reads
Katie and Emil
SQL Server Get Identity after Insert using SP
I thought I will share my experience how you can get identity value after insert using SQL Server. I have...
2012-07-03
630 reads
RSS pubDate format in SQL Server
Today I had to write T-SQL code to convert date into very specific date format (Mon, 02 Jul 2012 19:24:05...
2012-07-02
390 reads
Three reasons for normalization
In this article we cover three reasons for normalization (from our point of view). We created the article and included...
2012-07-02
290 reads
Database Interview questions
I decided to expand the collection of SQL Server Interview questions and this time focus on database objects related questions.
2012-07-01
963 reads
SQL Server Performance Tuning Overview
In this blog article I will give an overview of performance tuning based on common situation that occur on small...
2012-07-01
470 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