Shortly after configuring a new SQL Server 2012 server as a pull subscriber to a publication on a SQL Server 2008 Publisher/Distributor, we began receiving the following error message from the replication agents/jobs: The root cause, after much searching and testing theories, was permissions on the subscriber COM directory. The fix was to simply grant…
So I was recently installing SQL Server 2012 on a couple of new machines and ran into the following error when attempting to apply SQL Server 2012 SP1 CU1: This causes the SQL Server installation not only to be incompletely upgraded (Data Quality Services, Full-Text and Semantic Extractions for Search, SQL Server Replication, Database Engine…
Just ran into this one. If an SSRS report user comes to you indicating that they’ve attempted to created a subscription and, although it allowed the subscription to be created, the report subscription failed to be sent via email with the following Status: When troubleshooting, I found that the subscription owner account name did NOT…
Just a quick self-help note today……if you ever see the error message below with a SQL Agent Job calling an SSIS Package stored in SQL Server (MSDB database) and leveraging a Proxy built on a specific credential, ensure the credential under the proxy has membership in the db_ssisoperator role in MSDB. Without it (or a…
This post is part 3 of at least a 4 post article on my First Timer view of the SQL PASS Summit as I experienced it personally. If you missed the first posts, click here. Day 3 Day 3 for me, Day 2 of the Summit (Thursday) rolls around and today I’ve gotten up a…
This post is part 2 of at least a 4 post article on my First Timer view of the SQL PASS Summit as I experienced it personally. If you missed the first post, click here. Day 2 So day 2 began with a fairly early rise. I was staying about 10 blocks from the Washington…
So, as promised, I’m lightly documenting my experience as a first timer at the SQL PASS Summit. In the next few posts, I’ll be specifically covering the 2011 Summit, held in Seattle, WA. I’ll break it up by day, beginning with travel and what to expect. Also, there are plenty of other articles out there…
Well, the 2011 SQL PASS Summit in Seattle, WA, is fast approaching….2 weeks until the biggest SQL Server based technology community convergence begins and being an official first-timer, I’m not totally sure what to expect, but I’m planning to share every day what it’s like on this blog. To start things off right, I found…
Today I’m posting a turn-key solution for those of you out there supporting SQL Server replication. The purpose of the stored procedure created by the script provided below is simply to leverage a little-known, but very useful, tool provided by Microsoft for the sake of convergence validation (all your table based articles are identical between the publisher and subscriber(s)).
How do you normally provide SQL Server passwords to end users? Email, IM, a sticky note? Here’s another way if you’re anal about security like me.
Today I’m sharing a “quickly whipped script” to change the owner of SQL Agent Jobs to SA (or another of your choosing), so if the individual job owner were to leave the company and their AD account dropped, the job wouldn’t just begin failing. Feel free to use/modify/redistribute for any reason. SET NOCOUNT ON …
April 2011 WSSUG Meeting Topic: Accelerating your Database and Applications with Fusion-io Technology Date: Thursday, April 21st, 2011, 6-8:30PM Speaker: Brian Terry Location: Glorious Bible Church Overview: Fusion-io is a pioneering purveyor of NAND Flash based ioMemory –a non-volatile technology that physically acts like persistent memory, yet logically acts like disk. Our presentation will describe…
Documenting another solution for a problem I ran into today. Whilst attempting to connect to a SQL Server 2008 Analysis Services (SSAS) host, I was prompted with the following error: After fumbling around trying to figure out why the “princpal name was incorrect”, I tried the fully qualified domain name for the host and waalaaa,…
So today I’m posting about an issue with SQL Server replication. This particular posting is with regards to a SQL Server 2008 Enterprise 64-bit platform and transactional replication. The story goes like this: I was asked to add some new tables in a published DB to the transactional publication on the publisher to get replicated…
You have transactions stuck in the Transaction Log; the log won’t truncate; the log won’t shrink; the database is in Simple Recovery Mode; What do you do? (SQL Server 2008; DBCC LOGINFO; DBCC OPENTRAN;)
Beginning stages of the creation of the Wichita SQL Server Users Group is underway. Check back often for updates.
SSMS 2008 has a nasty little bug that Microsoft doesn’t seem to want to fix until the next major release of SQL Server. Less privileged users cannot see all of the 2005 SQL Server databases and objects in schemas for which are not their default schema. Permissions must be granted on the SQL Server 2005 databases for the users to re-enable something that works just fine in SSMS 2005.
Manage your SQL Server services via Configuration Manager remotely. Never RDP onto a server again just to check which services are installed and how they’re configured.
Has performance of your SQL Server running on a Windows 2003 server just gone south? Poor performance of T-SQL Queries, SSIS slow, linked server queries slow? Were Windows 2003 updates recently applied? Better check your TCP Offload, Receive Side Scaling settings. A real world experience.
This script will not only leverage SQL Server 2005+’s ability to recommend missing indexes, but will give you the create statement to create them.