Archives: July 2014
Short blog post this time as Website Pulse contacted me a few weeks ago with a few questions about working as a DBA. They’ve now published the article, it can be found at the following link:-
Let me know if you have any comments or feedback – firstname.lastname@example.org
Recently an incident came across my desk where an end user was receiving an error trying to retrieve some records from the database. The error message the customer received was “An error occurred while executing batch. Error message is: Arithmetic Overflow”.
Experience has taught me that this message is related… Read more
'Alert: SQL Failed Jobs on InstanceName is Failed'
Job name: LSRestore_InstanceName_DatabaseName
Date & Message: 2014-07-31 05:24:00.0 The job failed. The Job was invoked by User DOMAIN\LOGIN. The last step to run was step…
I am taking a slight deviation from the usual type of posts that I share. This time, I just want to share a quick and easy fix that I ran across due to a broken blog site that lasted for about a day starting on July 28th.
I didn’t even… Read more
- Email with the schedule went out this week, nice bump in registrations – we’re at 229 today
- Mailed the list twice (bad) because the bulk loaded list is a subset of the attendee list (need to get the criteria for each list)
- More emphasis on Twitter this week, trying…
Did you know that whatever columns you pick as your clustered index will be included in any non clustered indexes on the same table? But don’t take my word for it. Let’s take a look!
First things first I’m going to use some AdventureWorks2012 tables to make a test table. Read more
So the title says it all, right? Well, only really partially.
Recently an article was published listing the top 10 most recommended books for SQL Server. That’s the part the title doesn’t say. It is really important to understand that we are talking about the top 10 recommended books for… Read more
Today, We will go through with the steps of renaming or changing SQL Server Standalone Named Instance.
Renaming or Changing SQL Server Standalone Named Instance is almost same as SQL Server Standalone Default Instance. You can change a SQL server named SQLServerinstance1 to some other name, such as SQLServerNewinstance1, but… Read more
A recent Connector showed the following stats for SQLSaturday for the fiscal year ending June 30, 2014 and mentioned 86 events completed:
Impressive numbers to be sure, but are we adding events? Kendal Van Dyke sent me this projection he did while on the Board of Directors:
That… Read more
- In hindsight it’s easy to see we should have worked on the email template first, then the flyers. Email is our #1 way of communicating and it’s important to try to get as much out of it as possible.
- My original vision was to show the seminars as…
Executed as user: ArrivalsDepartures. The INSERT statement conflicted with the FOREIGN KEY constraint "FK_DepartureStatusArchive_TechnicianName". The conflict occurred in database "DatabaseName", table "dbo.Users", column 'UserID'. [SQLSTATE 23000] (Error 547) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (
so exciting), follow me on twitter (@StrateSQL). And see these throughout the day as I tweet out links of things I find interesting. While these links aren’t the answer… Read more
In the previous post I discussed how NULL is basically “unknown”. And any time you compare something to “unknown” you… Read more
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.)
Today I want to talk about a specific question that I almost get every time when I… Read more
I am very happy to announce that my first book “SQL Server 2014 Development Essentials” has now been published by Packt Publishing.
SQL Server 2014 Development Essentials is an easy-to-follow yet comprehensive guide that is full of hands-on examples, which… Read more
Wanted to explore one of the major limitation of CTE in sql 2012 i.e. it cannot be used inside if else statement . This is something basic as the definition of cte that it must be followed by a select, insert, update or delete statement.
That is we cannot…
Today I am going to report a bug in SSIS 2012. In one of the packages I was using execute sql task and then using ado.net foreach loop enumerator. My execute sql task had a simple select statement like - 'select c1,c2,c3 from table' where c1,c2,c3…