Fixed Database Rols are: db_ddladmin, db_owner, db_accessadmin, db_securityadmin, db_backupoperator, db_datawriter, db_datareader, db_denydatawriter, db_denydatareader + one more that is dbm_monitor.
This is...
2010-06-03
1,686 reads
I have non-official info about the Microsoft event, and the only event, TechUpdate Prishtina, in Kosova. The event will be...
2010-06-02
501 reads
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
562 reads
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,705 reads
Thomas LaRock (SQL Server MVP) (Blog | Twitter | LinkedIN), recently has published the new book DBA Survivor: Become a Rock Start...
2010-05-14
815 reads
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,056 reads
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,237 reads
MS Access have a nice possibility if you want to connect with SQL Server databases and manipulate with data in...
2010-05-11
13,806 reads
SET clause in SQL Server uses in combination with other clauses to change the current behavior of the SQL Server...
2010-05-07
5,426 reads
DBAs & Developers using everyday UPDATE statement, and everytime before update they want to see what to update, after this they...
2010-05-06
3,482 reads
I wanted to figure out how big (or approximately how big) my dump file...
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
I have a table. Structure in script below. I have to compare and see...
I have an application team that is insisting on daily (and for some, weekly)...
i see this in the definition of a linked server on our wh sql...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers