When it comes to managing your business data, you want a system that’s rock solid. Microsoft SQL Server is a popular choice, but like any complex software, it needs proper care and attention. That’s where reliable SQL Server assistance services come in. Think of it as having a trusted mechanic for your car - someone who knows the ins and outs and can keep things running smoothly without you having to lift a finger. Let’s dive into why these services matter, what they cover, a

Alright, let’s get real for a moment. If your SQL Server feels like it’s running through molasses, you’re not alone. Databases can be tricky beasts, and when they slow down, everything else feels the pinch. But don’t worry - I’m here to walk you through some practical, no-nonsense database tuning strategies that can seriously boost your system’s speed and reliability. Think of it as giving your SQL Server a much-needed energy drink. Why Database Tuning Strategies Matter Imag

Let’s face it - managing Microsoft SQL Server can sometimes feel like juggling flaming torches while riding a unicycle. You want your data safe, your queries fast, and your downtime minimal. But when things go sideways, who do you call? That’s where reliable SQL Server support help steps in. Whether you’re running a bustling business, managing IT infrastructure, or steering a non-profit’s data ship, having expert backup is not just a luxury - it’s a necessity. In this post, I

Migrating your SQL Server environment can feel a bit like moving house. You want everything to go smoothly, nothing to break, and no surprises when you unpack. But unlike packing boxes, SQL migration requires a bit more finesse and planning. Don’t worry, I’m here to walk you through the process with some practical tips, a dash of humour, and clear steps to make your transition as painless as possible. Why SQL Migration Planning Matters Imagine trying to move your entire offic

Alright, let’s get real. If you’re managing Microsoft SQL Server environments, you know that performance tuning can sometimes feel like trying to solve a Rubik’s cube blindfolded. But don’t worry - I’m here to walk you through some practical, no-nonsense sql performance tips that will help you speed up your queries, save money on licensing, and reduce those pesky operational risks. Ready? Let’s dive in. Why SQL performance tips Matter More Than You Think Imagine your SQL Ser

Alright, let’s get real for a moment. If you’re managing Microsoft SQL Server databases, you know that performance can sometimes feel like a slippery fish. You chase it, it slips away. But what if I told you that optimizing your database performance doesn’t have to be a wild goose chase? With a few smart moves, you can reel in that slippery fish and keep it on your line. Ready? Let’s dive in. Why You Should Care About Optimizing Database Performance Imagine your database as t

Let’s face it - managing a database can sometimes feel like trying to herd cats. You want everything neat, tidy, and running smoothly, but the reality is often a bit messier. That’s where SQL service options come into play. They’re like your database’s personal assistant, making sure everything is in order, optimised, and ready to perform at its best. Today, I’m going to walk you through how you can enhance your database with these services, making your life easier and your

tl;dr. Look for the SQL files here, https://github.com/SQLAdrian/drawingWithSSMS The premise is quite simple, to draw something in SSMS using the spatial results tab . The easiest way to do this is to pick an image and convert it into something that SQL Server can understand. My intent was, and still is, to provide you with some guidance on how to create your own image in SQL Server Management Studio, and I provide this further in this article. You will find this article r

See how using CNAMEs during SQL migrations can reduce risk and save time with fever reconfiguration needed. CNAMEs are great Migrations are full of risk and CNAMEs offer a great way to mitigate some of that risk. It also saves a lot of time and reduces overall configuration complexity. If you are brave enough to do in-place upgrades then this one isn't for you though. For the rest of us however there is a simple way to point all the old server names to your brand new SQL ins

I'm sure you are familiar with SSPI errors like the following: SSPI handshake failed with error code 0x80090311, state 14 while establishing a connection with integrated security; the connection has been closed. Reason: AcceptSecurityContext failed. The Windows error code indicates the cause of failure. No authority could be contacted for authentication. [CLIENT: <IP>] Trust Well Microsoft has a super easy tool for configuring SPNs called Microsoft® Kerberos Configuration Man

With many great SQL scripts out there to monitor and report on issues and risks in a SQL server environment it is easy to get lost in what is really important, and what can be ignored. Summary: Defining a Framework for SQL Server Risk Assessments Creating a robust framework for conducting SQL Server risk assessments is essential for daily DBA checks. This framework should encompass several key components to ensure thorough evaluation and management of risks associated with S

Perceptive Software released the latest SAPERION ECM Patch Level Upgrade this December and I don’t blame you for thinking that you must be on Santa’s naughty list for getting this little gem this festive season. But before your festive cheer gets spoiled by getting dog eggs in your Christmas stockings., here are some tips to help you get your updates right every time. Before beginning this let us outline how your folder structure should look. You should have 2 main folder set

Caveat -This is just my understanding, so it is probably fundamentally flawed, but this is how I understand things and hopefully I can impart some of that understanding to you of how DPM and SQL server spend their time where prying eyes cannot see. I do not read the type of books that would allow me to convey the right mood for a story like this, for which I am very thankful, however, it diminishes the potential appeal of this story. Let’s face it, SQL Server is pretty dull a

This is a quick guide on how to setup automated metadata capturing from scanned documents. Assuming you are a Saperion Administrator this should be rather simple. If you don’t know what anything here is, ask. 1. Let us decide what to call what. Saperion calls thins other names, so lets call the scanning overlay that defines where what items will be captured as the Document Formats. You will find this under Design > Tables > Document Formats 2. Now lets us load the DDC. The Do

Let us start with what Saperion is. Lexmark’s Perceptive Software (NYSE: LXK), builds intelligent capture, content management, process management, enterprise search and integration products that connect the unstructured printed and digital information across enterprises with the processes, applications and people who need it most. So, in short, Saperion is an Enterprise Content Management solution. It does all the nice document management things and throws in some nice workfl

Trello – let’s say you want to organize some tasks, like say anything-you-can-think-of, you can use Trello. We use it to manage our Tasks and Projects in IT. It really is an awesome tool and the price is great, free, my type of budget that, but we need to expand it a bit so we can report it to death. In that way we can prove we are really busy and our nice fat bonuses are justified, and that new HP Elitebook 850.. and my home DSL.. and my cellphone. So in order to see if I ca

Need to add a feature or something on SQL but you cant’ because there is a restart pending? Well let me show you how. Before proceeding you need to understand that you might just break something, there is a reason your computer wants to restart. If there was a SQL update and you are making changes before the restart you might just cause something detrimental, or you might not. But you are a SQL expert ,so no issues there. This is the issue in question. There is only 1 way to

Wow, I found so many nice posts on how to do this using  registry queries, but seeing as I have a list of over 100 servers on geographic disparate areas, the scripts were running for ages. So I though why not just use Get-WmiObject. So here is the juicy bits $inputfile = "$scriptlocation$serverlistfile"; $servers = get-content $inputfile; #Create container $SQLservers = @() ; foreach($server in $servers) { if($server.length -gt 4) { $Computer = $server -replace '(.*?)\..+',

Well in SQL Server 2012, to be quite blunt, [sys].[sp_dboption] has been deprecated, dumped, canned or if  you prefer, sent to Zim. Now isn’t that just dandy..because you will only realise this only when it is too late. But on the other hand Darren, you can always do a quick fix, all you need is an earlier flavour of SQL Server and some creative thinking. Open SSMS and explore your database in question. If you don’t find [sys].[sp_dboption], just grab it off a SQL 2008 Ser

If you are into caching and reuse of existing query execution plans, which no doubt excites you as much as it does me, you probably use OPTION(OPTIMIZE FOR UNKNOWN) in most of your queries. If, however, you are not tickled by SQL performance optimization, shame on you, you might want to have a look at this to help make some of your queries run a bit smoother. You can read more about this at OPTIMIZE FOR UNKNOWN – a little known SQL Server 2008 feature , thanks Peter Scharlock