TechUpdate Prishtina 2010, announcement
I have non-official info about the Microsoft event, and the only event, TechUpdate Prishtina, in Kosova. The event will be...
2010-06-02
504 reads
Dukagjin Maloku - Dugi'DBA
It's Free, It's Non-Stop, It's 24 Hrs of PASS
Yea, it's FREE, it's NoN-Stop, it's 24 hours of PASS! Many of the bloggers have wrote about 24 Hrs of...
2010-05-17
563 reads
Tips from ...Rock Star DBA
Thomas LaRock (SQL Server MVP) (Blog | Twitter | LinkedIN), recently has published the new book DBA Survivor: Become a Rock Start...
2010-05-14
816 reads
SQL Azure and T-SQL
SQL Server Azure database supports the T-SQL, but no at all! For the SQL Server Azure and T-SQL are available...
2010-05-14
8,710 reads
SQL Server Azure features limitation
SQL Server Azure, fully relational cloud database solution, is new possibility of the database administration and maintenance. I'm not going...
2010-05-13
1,060 reads
SQL Server 2008 R2 backup/restore - simple Tip
Simple, but I think somebody will ask:
Can restore the SQL Server 2008 R2 database to SQL Server 2008 ?
Simple answer,...
2010-05-12
10,241 reads
SQL Server with MS Access .adp Project file
MS Access have a nice possibility if you want to connect with SQL Server databases and manipulate with data in...
2010-05-11
13,850 reads
SET clause in SQL Server (2008/2005)
SET clause in SQL Server uses in combination with other clauses to change the current behavior of the SQL Server...
2010-05-07
5,429 reads
Viewing the results before and after, during Update
DBAs & Developers using everyday UPDATE statement, and everytime before update they want to see what to update, after this they...
2010-05-06
3,486 reads
SQL Server 2008(R2) and Win Server 2008 R2 Core Edition
The WinServer 2008 Core Edition was the server that you cannot install the SQL Server 2008. The Win Server 2008...
2010-05-02
1,511 reads
Blogs
Creating a Striped Backup Set with AI
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
Trace Flag 1448 – Lessons from a Technical Interview
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Disable the sa login in SQL Server (and sleep better)
Disable the sa login in SQL Server (and sleep better)If you run SQL Server...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Telegram(@Wheel202) 5mio dmt cart, gbl wheel cleaner CAS 96-48-0.
Signal(@Remedy.73) GBL gamma butyrolactone wheel cleaner online vendors in Ottawa Canada, New York USA,...
SQLPS and syspolicy_purge_history job
The SQLPS.exe file has gone AWOL on 2 of my 4 SQL servers, ie,...
Question of the Day
Locking Hierarchies
You have a table [dbo].[orders] without a Clustered Index (Heap). The table does not have any other nonclustered indexes! You rund the following command in Read Committed Isolation Level:
SELECTo_orderdate,
o_orderkey,
o_custkey,
o_storekey
FROMdbo.orders
WHEREo_orderkey = 3877;