Event ID 7026 and i8042prt troubleshooting
Event ID 7026 and i8042prt is a recurring error in the Windows Event Logs. I usually see this error on...
2012-03-22
7,235 reads
Blog Posts
How do you secure the SQL Server instance after enabling xp_cmdshell ?
OR
How do you allow non-administrator to use xp_cmdshell ?
From the day I started working with SQL server, I have heard
about...
2012-03-22
4,547 reads
March #Meme15 Round-up – Facebook
Are you ready for the round-up of last week’s #meme15 Facebook question?
In total, there were eight participants in this month’s...
2012-03-22
1,016 reads
Restore fails with tail of log error
For sql server 2005 and above, When you take a full backup of the FULL recovered database and try to...
2012-03-22
680 reads
RYO Maintenance Plan – History Cleanup
The last step in our campaign to rid the world of maintenance plans deals with housekeeping: the history cleanup step....
2012-03-22
986 reads
2012-03-22
4 reads
SQL Server 2012 Unattended Installation on Windows Server 8
In part 5 will install SQL Server 2012 on 3 Windows Server 8 VM’s using GUI and unattended installation to...
2012-03-22
1,117 reads
2012-03-22
11 reads
2012-03-22
3 reads
2012-03-22
2 reads
Blogs
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
CMS server query & temp tables
I am annoyed. We have a CMS server that has hundreds of servers saved...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers