Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Latest Blog Posts


Error:  The server principal "IncidentManagement" is not able to access the database "DatabaseName" under the current security context.
for conection string: "Data Source=SBCAPPDEV1.curvature.com;Initial Catalog=DatabaseName ;User Id=IncidentManagement ;Password=wuwaye6U5+uz;" providerName="System.Data.SqlClient"


Fix: This error you receive when the service account using from .net application doesn’t have sufficient permissions to access the…

Read more

0 comments, 0 reads

Posted in SQL Articles by Nani on 2 December 2016

Lock request time out period exceeded. (Microsoft SQL Server, Error: 1222)



Issue: I see this issue when I try to expand the databases and any other things in object explorer of secondary replica of AlwaysOn SQL instance. I have seen few blogs which suggests to see sp_who2 results and kill blocking. Unfortunately this is  read only database and no user connections…

Read more

0 comments, 1 read

Posted in SQL Articles by Nani on 2 December 2016

Adding database back to Always On High Availability Group

            
Summary: If databases in secondary replica are out of sync with primary then below is the workaround which helps to fix.

1)      At very first take the database out of Always on availability group on primary replica by right click on the…

Read more

0 comments, 41 reads

Posted in SQL Articles by Nani on 2 December 2016

VIEW SERVER STATE permission was denied on object 'server', database 'master'. (Microsoft SQL Server, Error: 300)

Issue: I had to create few users for the first time and give access to execute views from user database. I have created logins for them and gated access to select from views and tables at object level but see below error when they select from views.

Error:

TITLE: Microsoft…

Read more

0 comments, 70 reads

Posted in SQL Articles by Nani on 2 December 2016

Moving Tasks with Copy-SqlJob

More dbatools experimentation for me. This is a great set of Powershell cmdlets that solve simple, handy problems. In this post, I want to look at Copy-SqlJob, which will allow me to easily move jobs from one instance to another.

The Job Subsystem

Jobs in SQL Server are part… Read more

0 comments, 66 reads

Posted in The Voice of the DBA on 2 December 2016

SSIS Naming Conventions 2.0

People who have been working for a while with Integration Services probably know the legendary blog post by SQL Server MVP Jamie Thomson: Suggested Best Practises and naming conventions. The blog post served as a guidance point for many SSIS projects regarding naming conventions of the various tasks and… Read more

0 comments, 77 reads

Posted in Koen Verbeeck on 2 December 2016

Friday Reading 2016-12-02

Another week almost over so here’s a random selection of articles that I’ve been reading…

Changing the SQL Server port on Linux
Denis Gobo goes through the process of changing the port that an instance of SQL Server running on Linux is listening on

Reload a table quickly
Kenneth Fisher… Read more

0 comments, 67 reads

Posted in The DBA Who Came In From The Cold on 2 December 2016

I use Elastic database pools – for now

When you have many SQL databases that are required to run your environments and  they show signs of specific usage patterns and some of the databases requires different performance levels then how can you ensure that the all the databases … Continue reading

Read more

1 comments, 194 reads

Posted in All About SQL on 2 December 2016

Hey Posh, Are My Services Running?–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

In a previous post, I looked at escaping strings. The reason I needed to do this was that I was trying to do some automatic work… Read more

0 comments, 108 reads

Posted in The Voice of the DBA on 1 December 2016

Problem where you can only browse Google websites

Note: not a SQL/BI related post like usual, but since it’s a common issue I want to share my solution here

Quite recently I had a bizarre issue on my laptop: suddenly I could only browse Google websites (Google search, YouTube, Gmail …). All the other websites would time out… Read more

0 comments, 84 reads

Posted in Koen Verbeeck on 1 December 2016

Azure pricing

Not a technical post today (not that I am technical) but still an important one. I have been using Azure for 1.5 years now and I am still fascinated by the ever-changing technology. Talking of ever-changing, I had a nice … Continue reading

Read more

1 comments, 230 reads

Posted in All About SQL on 1 December 2016

SSIS Data Flow "Sequence Containers" are Here!

Wooo!

OK - maybe too much of a celebration... and I do have meatier topics in the article pipeline.  However, I just stumbled across a feature in SSIS that I didn't realize had been included - due to a Connect item I'd raised a long time ago (in early 2009). …

Read more

0 comments, 88 reads

Posted in Todd McDermid's Blog on 1 December 2016

SQL Server – Playing With Trace Flags

Trace flags are used to temporarily set specific server characteristics or to switch off a particular behavior. They are usually scoped to a global level or a session only level. For this blog post I thought it would be handy … Continue reading

Read more

1 comments, 286 reads

Posted in All About SQL on 1 December 2016

MSDB log file grown large – SLEEP_MSDBSTARTUP waittype

Issue: MSDB database log file is getting full very rapidly and became very huge. Currently, T-Log file is of 5GB whereas Data file is only 1GB for MSDB on server.

Findings: We found system owned open transaction in MSDB which is causing issue.

Transaction information for database ‘msdb’.

Oldest active… Read more

0 comments, 87 reads

Posted in MSSQLFUN on 30 November 2016

What’s the little popup window in #SQLPrompt?

Awhile back I was working in SSMS and saw this window.

It threw me off since I was trying to write some code and hadn’t expected it. I clicked Escape, Enter, a few things and was getting frustrated when it disappeared.

I ignored it until I saw the window again… Read more

0 comments, 117 reads

Posted in The Voice of the DBA on 30 November 2016

This Week in Data – Episode 14 (Hacking Your Professional Development)

Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them here. In this week’s episode, we discuss hacking your own professional development.

Having a plan for your professional development is essential when tackling your career goals. You need to have… Read more

0 comments, 107 reads

Posted in Devin Knight on 30 November 2016

Query Tuning 101: Debugging a procedure

I was recently asked to help tune a stored procedure that has been historically taking between 55 and 60 seconds to complete. Overall the code wasn’t too complex but getting to the root cause did surprise me a bit.

We run a mixture of SQL Server 2008 R2 and SQL…

Read more

0 comments, 123 reads

Posted in Confessions of a Microsoft Addict on 30 November 2016

Reflecting on Ten Years of SQLSaturday

It’s hard to believe it’s been more than 10 years since we started the planning for the first event in Orlando. The success of the idea seems obvious now – surely the time was right for something to happen in our space. Back then though it was far from obvious.… Read more

0 comments, 82 reads

Posted in SQLAndy on 30 November 2016

Using OUTPUT with a field list.

I recently wrote an article for SQL Server Central about using OUTPUT. In case you aren’t aware OUTPUT is a clause that lets you output the changed data from an INSERT, UPDATE, DELETE, or MERGE statement. One of the comments on the article was a question… Read more

2 comments, 89 reads

Posted in SQLStudies on 30 November 2016

SQL Server & Containers – Part Three

This post follows on from Part Two in which we created a custom docker image. We’ll now look at pushing that custom image up to the Docker repository.

Let’s quickly check that we have our custom image, so run (in an admin powershell session):-

docker images

If you’ve followed Part… Read more

2 comments, 81 reads

Posted in The DBA Who Came In From The Cold on 30 November 2016

Older posts