Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Conquering Kilimanjaro & Cancer !

Day 1 – Leaving for Africa
After almost 12 months of fundraising, training, walking up various mountains, sleepless nights and plenty of nervous anticipation, the day had finally arrived! I was leaving for Africa to take on all 19,304ft of Mount Kilimanjaro.
The idea of taking on this challenge for… Read more

0 comments, 199 reads

Posted in DatabaseExpertise.com on 8 February 2011

Denali is coming…..

SQL Server 11 (code-named “Denali”)

Heres the official MS speak:-
Microsoft SQL Server code-named “Denali” empowers organizations to be more agile in today’s competitive market. Customers can efficiently deliver mission-critical solutions through a highly scalable and available platform. Industry-leading tools help developers quickly build innovative applications while data integration and… Read more

0 comments, 226 reads

Posted in DatabaseExpertise.com on 6 January 2011

Free e-books

I had stumbled across the free(!) Microsoft SQL Server 2008 R2 ebook, but I was also pointed in the direction of more free e-books here.
And given the current financial climate, I plan on taking advantage of these freebies !

Anybody know of anymore let me know please ! Read more

5 comments, 385 reads

Posted in DatabaseExpertise.com on 5 January 2011

SQL Server 2005 SP 4

 
Finally, after SQL Server 2005 SP3 was released Dec 2008, SP4 is now available for download.

To download visit Microsofts Download Centre

Has anyone had any issues we should be aware of after installing this ? I’m doubting there are many, if any significant functionality improvements? Or are we better… Read more

0 comments, 307 reads

Posted in DatabaseExpertise.com on 5 January 2011

Ben Nevis Nov 2010

Ben Nevis – November 2010

Last major training trek before Kili !!

Was pretty cold up in Scotland………

Read more

0 comments, 194 reads

Posted in DatabaseExpertise.com on 5 January 2011

Why do you use Sparse Columns ? (by Abi Chapagai)

What uses have you found for sparse columns in your databases?

 
SPARSE columns is a new feature in SQL Server 2008. This feature enables developers/DBAs or others who work with SQL Server database to store null values very effectively. In ideal scenario, if the column is NULL, than with this… Read more

0 comments, 1,245 reads

Posted in DatabaseExpertise.com on 31 October 2010

Training begins in earnest !

In almost 12 weeks time, I’m embarking on a challenge of a lifetime. I’m scaling Africas highest peak, Mount Kilimanjaro to raise much needed funds for cancer research carried out at a local centre – Velindre (http://www.wales.nhs.uk/sites3/home.cfm?orgid=357)

I have started training and ventured up many of the finest… Read more

1 comments, 170 reads

Posted in DatabaseExpertise.com on 19 October 2010

Transactional Replication Setup (by Abi Chapagai)

As I discussed in my first part of replication SQL Server 2008 Replication: High Availability Solution Part One, replication is the process of moving data and database schema changes from one database to another server, either on the same server in different instances or on different server databases.

In… Read more

11 comments, 7,704 reads

Posted in DatabaseExpertise.com on 3 October 2010

Idera SQL Tools – An evaluation (Part 2)

This is the 2nd in the series of evaluations I have carried out on Idera’s SQL Server Toolbox. The first one focused on Idera SQL Server Admin Toolset (http://databaseexpertise.com/2010/09/idera-sql-tools-an-evaluation/).

This next one introduces a relatively new Idera addition – the SQL Comparison Toolset.

SQL comparison toolset

Ever… Read more

1 comments, 591 reads

Posted in DatabaseExpertise.com on 6 September 2010

Idera SQL Tools – An evaluation

Idera SQL ToolBox

(http://www.idera.com/Products/SQL-toolbox/)

The datasheet for ToolBox – asks the question – Want an Easy way to save money? No manager is going to answer that negatively! But does the product live up to its billing of a Best of TechEd 2010 award winner? After all 298… Read more

0 comments, 829 reads

Posted in DatabaseExpertise.com on 2 September 2010

Whats best SQL Server or Oracle ?

Im often asked the question – whats best SQL or Oracle ?

The Oracle guys will tell you that SQL Server does not have as many  capabilities and features which Oracle has (or certainly 2 years ago they would have !) - and vice versa – SQL guys will claim… Read more

0 comments, 279 reads

Posted in DatabaseExpertise.com on 2 September 2010

Return top 20 queries by Average CPU

I’ve recently used this when troubleshooting some unexplained high CPU load on my server:

select top 20
st.objectid, st.dbid, total_worker_time/execution_count AS AverageCPUTime,
CASE statement_end_offset
WHEN -1 THEN st.text
 ELSE
SUBSTRING(st.text,statement_start_offset/2,statement_end_offset/2)
END AS StatementText
from  sys.dm_exec_query_stats qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) st
ORDER BY AverageCPUTime DESC

Read more

3 comments, 2,042 reads

Posted in DatabaseExpertise.com on 31 August 2010

How to fix Orphaned Users

 To view if there are any orphaned users, run this query against the DB;

 sp_change_users_login ‘report’

To fix;

 sp_change_users_login ‘update_one’, ‘dbUser’, ‘sqlLogin’

Read more

2 comments, 943 reads

Posted in DatabaseExpertise.com on 31 August 2010

Determining the no of processor cores in your SQL Server

SELECT cpu_count/hyperthread_ratio AS cores
   FROM sys.dm_os_sys_info;

Read more

0 comments, 646 reads

Posted in DatabaseExpertise.com on 31 August 2010

Hunting down those expensive SPs

A query to find out which Stored Procedures are taking the longest to run ( in this example – the Top 10).

I’m sure there are many other ways but this is a quick and easy script I found.

SELECT TOP 10 obj.name, max_logical_reads, max_elapsed_time
FROM sys.dm_exec_query_stats A
CROSS APPLY…

Read more

0 comments, 235 reads

Posted in DatabaseExpertise.com on 19 August 2010

Undocumented Stored Procedures

Just a quick list of undocumented SPs, many of which are deprecated.

Note, use caution using some of these ! But others are very useful (e.g. sp_msforeachdb)

sp_checknames
sp_columns_rowset
sp_enumoledbdatasources
sp_fixindex
sp_gettypestring
sp_ms_marksystemobject
sp_msaddguidcolumn
sp_msaddguidindex
sp_msaddlogin_implicit_ntlogin
sp_msadduser_implicit_ntlogin
sp_mscheck_uid_owns_anything
sp_msdbuseraccess
sp_msdbuserpriv
sp_msdependencies
sp_msdrop_object
sp_msforeachdb
sp_msforeachtable
sp_msget_qualified_name
sp_msgettools_path
sp_msgetversion
sp_msguidtostr
sp_mshelpcolumns Read more

0 comments, 906 reads

Posted in DatabaseExpertise.com on 19 August 2010

Neat script to monitor activity

Scouring the web this week, I stumbled across SQL Server MVP Adam Mechanics and his script :-

Who is Active?

Its basically a  stored procedure that helps you monitor SQL Server activity quickly and efficiently. Bit like sp_who but with extras ! You can read more over here as… Read more

0 comments, 281 reads

Posted in DatabaseExpertise.com on 19 August 2010

Synchronizing SQL user in Database Mirroring- Abi Chapagai

Synchronizing SQL user in Database Mirroring:

 If a login used in an application that involves database mirroring has SQL Login, there can be issues with login failure. While I was working with database mirroring set up between two databases in different server, I ran into an issue where I was… Read more

0 comments, 1,127 reads

Posted in DatabaseExpertise.com on 16 August 2010

Different High Availability Solutions in SQL Server

Different High Availability Solutions in SQL Server.

While working on finding different High Availability solutions, I did quite a bit of research on various methods of DR solutions and I wanted to share following technologies are available in SQL Server for us to implement DR solution. In this cutting edge… Read more

5 comments, 3,108 reads

Posted in DatabaseExpertise.com on 12 August 2010

Different High Availability Solutions in SQL Server – By Abi Chapagai

Different High Availability Solutions in SQL Server.

While working on finding different High Availability solutions, I did quite a bit of research on various methods of DR solutions and I wanted to share following technologies are available in SQL Server for us to implement DR solution. In this cutting edge… Read more

0 comments, 1,698 reads

Posted in DatabaseExpertise.com on 12 August 2010

Newer posts

Older posts