(Arshad Ali) SQL Server introduced four new ranking functions either to rank records in a result-set or to rank records within groups of records of a result-set. With these new functions, we are no longer required to write several lines of code to get ranking data. It does not only help in simplifyi

(Mike Chapple) The Declarative Management Framework allows you to manually reconfigure policy targets so that they comply with some policies. It is important to note, however, that this manual reconfiguration cannot resolve all policy compliance issues. SQL Server will be able to modify database set

(Brendan Cournoyer) If there is one area that Microsoft focused on when it developed SQL Server 2008 R2, it was business intelligence. Ready for general availability in the first half of 2010, the company’s latest database management system (DBMS) is packed with supported BI improvements like the up

(Chris Skorlinski) Following a user database restore the database had orphaned users. We used TSQL commands below to build a list of sp_change_users_login commands in order to resynchronize database users with SQL logins. We then ran these sp_change_users_login commands to automatically fix the us

(Tim Ford) I get so frustrated when trying to determine where to start when a user comes to me and tells me that “the database is slow”. Launching Performance Monitor and running a trace in Profiler is inefficient. Unless I know what I’m looking for to begin with it’s hard to narrow things down us

(Anu Chawla) Our March 17 post discussed index fragmentation and introduced you to a script that we use to determine index fragmentation. This is a follow-up that explains the script. Just as a reminder—index fragmentation is a bad thing. It degrades performance and makes ENOVIA V6 run slower on SQL

(Michael Otey) Self-service business intelligence (BI) is a great thing—it brings the power of analysis to knowledge workers and decision makers who can make use of it directly.

(Indrajeet Sutar) Every organization has its database and each and every day with the increase in the data volume these organizations has to deal with the problems relating to data retrieval and accessing of data. There is need of system which will results into increase in the data access speed. An

(Pinalkumar Dave) Snapshot database is one of the most interesting concepts that I have used at some places recently.

(Edwin Sarmiento) In previous tips on Windows PowerShell with SQL Server, you’ve seen how you can use Windows PowerShell and SMO to administer SQL Server databases. Most of the examples have used Windows authentication to connect to SQL Server. How can I connect to SQL Server via Windows PowerShell