SQL Server 2008 R2 Update for Developers Training Kit
It is a good news for developers! Microsoft published the Training Kit for SQL Server 2008 R2.
The content of...
2010-02-05
595 reads
Dukagjin Maloku
- Interests: Database Admin & BI
Azure platform CTP accounts are about to expire?
I recieved the notification from Azure Platform Team that the CTP accouct will be closed at the end of the...
2010-01-21
389 reads
SQL Server 2008 R2 - official date
Since the August 2009 when the CTP ( Community Technology Preview) version was available, the Microsoft announced the offical release date...
2010-01-21
448 reads
Windows Azure Platform Training Kit
Everyone interesting for Windows Azure Platform Training Kit - December Update, can find it from Microsoft location here.
There are lot of...
2010-01-20
960 reads
GodMode - in Windows 7
It's very interesting if you create new folder with name:
GodMode.{ED7BA470-8E54-465E-825C-99712043E01C}
Try it and you will find a lot of stuff there...
2010-01-10
524 reads
Little info about Resouce DB (SQL Server 2008-2005)
Little info about System Resource Database in (SQL Server 2008/2005)
The fifth system database in both versions (SQL Server 2008 - 2005)...
2009-12-29
2,258 reads
Little info about Resouce DB (SQL Server 2008-2005)
Little info about System Resource Database in (SQL Server 2008/2005)
The fifth system database in both versions (SQL Server 2008 - 2005)...
2009-12-28
1,374 reads
SQL Profiler ...Error ...Click OK to terminate program
Hi to everyone! I decide to write it in my blog here about this problem because really don't have any...
2009-08-27
1,305 reads
ALSSUG...soon!
Yes, ALbanian SQL Server User Group will start soon with first meeting and registering the new users. So we will...
2009-06-17
508 reads
Tech Ed 2009: Best of Tech Ed Winners Announced
The best of Tech Ed in Los Ageles award winners were selected from Windows IT Pro and SQL Server Magazine,...
2009-05-15
499 reads
Blogs
10 Decisions to Make Before You Create A Fabric Workspace
Creating a Fabric workspace takes about 30 seconds. Restructuring workspaces after people have built...
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Forums
Alamat BCA KCP Cempaka Putih Telp:08218520153
WhatsApp CS 628218520153 Jl. Letjen Suprapto No.30 EF, RT.7/RW.2, Harapan Mulya, Kec. Kemayoran, Kota...
Alamat BCA KCP Menteng Telp:08218520153
WhatsApp CS 628218520153 Jl. HOS. Cokroaminoto No.83, RT.3/RW.5, Menteng, Kec. Menteng, Kota Jakarta Pusat,...
Alamat BCA KCP Wahid Hasyim Telp:08218520153
WhatsApp CS 628218520153 Jl. K.H. Wahid Hasyim No.82, RT.15/RW.3, Kb. Sirih, Kec. Menteng, Kota...
Question of the Day
Adding new column with DEFAULT II
Which number did the two COUNT(*) return:
DROP TABLE IF EXISTS #tmp CREATE TABLE #tmp (id INT NOT NULL) INSERT INTO #tmp (id) SELECT gs.value FROM GENERATE_SERIES(1, 5) AS gs ALTER TABLE #tmp ADD my_value INT NOT NULL CONSTRAINT df_tmp_my_value DEFAULT 1 SELECT COUNT(*) FROM #tmp AS t WHERE my_value = 1 ALTER TABLE #tmp DROP CONSTRAINT df_tmp_my_value ALTER TABLE #tmp ADD CONSTRAINT df_tmp_my_value DEFAULT 2 FOR my_value SELECT COUNT(*) FROM #tmp AS t WHERE my_value = 1See possible answers