-
31 maj 2013 i T-SQL, SQL Server 2008, SQL Server 2008R2, SQL Server 2012, Level 200, SQL Server maintenance, Håkan Winther, sv
In SQL server there is an undocumented extended stored procedure called xp_servicecontrol. You can use this to start/stop and view the state of the
-
27 maj 2013 i Mattias Lind, SQL Server 2008R2, SQL Server 2012, Level 200, Level 300, SQL Server best practices, SQL Server konsolidering, SQL Server maintenance, SQL Server, sv
Från och med SQL Server 2008 R2 har vi ju officiellt stöd för SMB, dvs att låta databasernas data- och logfiler vara adresserade med UNC-sökvägar. T...
-
26 maj 2013 i Level 300, SQL Server allmänt, SQL Server maintenance, Steinar Andersen, sv, en
In my previous blogpost I shared a way to do general purpose monitoring of your SQL Server environment using Zabbix, and a Zabbix template that I have...
-
19 maj 2013 i Level 200, SQL Server allmänt, SQL Server maintenance, Steinar Andersen, SQL Server, sv, en
There are many ways to monitor Microsoft SQL Server, too many to even list them here. And there are a lot of things to monitor for, depending on your...
-
30 mars 2013 i T-SQL, Level 200, SQL Server maintenance, SQL Server performance, Steinar Andersen, sv, en
When you think about monitoring SQL Server instances, you probably often think about monitoring that the service is up, performance, security and such...
-
06 mars 2013 i Mattias Lind, T-SQL, SQL Server maintenance, SQL Server, sv, en
If you would like to query the ERRORLOG with T-SQL you have the undocumented procedure SP_READERRORLOG. But as it's a procedure filteriung the result...
-
03 februari 2013 i SSRS, Level 100, SQL Server allmänt, SQL Server best practices, SQL Server maintenance, Steinar Andersen, SQL Server, sv
Vi på SQL Service brukar gärna skriva och prata om fördelarna med Enterprise Edition av Microsoft SQL Server, bland annat när det gäller prestanda och...
-
27 januari 2013 i SQL Server 2012, Level 200, SQL Server maintenance, Steinar Andersen, sv, en
Recently, SQL Server 2012 Servicepack 1 Cumulative Update 2 was released. And unlike some CU's this one has quite som extra functionality in it, not...
-
27 januari 2013 i SQL Server 2012, Level 200, SQL Server allmänt, SQL Server maintenance, Steinar Andersen, sv, en
If you install a lot of servers, you are probably aware of a tool called Sysprep, that is used to take an windows installation and remove all specific...
-
20 januari 2013 i Verktyg, SQL Server 2008, SQL Server 2008R2, SQL Server 2012, Level 100, SQL Server maintenance, Steinar Andersen, sv, en
Sometimes you need to compare the schema or contents of two tables. There are many good tools for that available, but you might be a little surprised...