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
505 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
566 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
818 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,711 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,062 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,243 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,856 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,432 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,489 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,512 reads
Blogs
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Azure SQL Managed Instance Next-Gen: Bring on the IOPS
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Forums
Two foreign keys to the same table. Can't cascade deletes.
Not sure if this is really a relational theory question but it seems about...
Connecting Power BI to SSAS and effective user not working
Hi everyone, Below is a consolidated summary of what we validated Architecture & data...
High Availability setup - has anyone seen this method?
Hi all, I recently moved to a new employer who have their HA setup...
Question of the Day
Encoding URLs
I have this data in a SQL Server 2025 table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers