Profile cover photo
Profile photo
Spiner Tsai
17 followers
17 followers
About
Posts

Post has attachment
Access SQL Server Configuration Manger of remote instances via Microsoft Management Console
You can connect to SQL Server Configuration Manager via Microsoft Management Console (MMC) to remotely manage SQL Server instances, which is especially useful when dealing with the instances deployed on Server Core. Before you connect it, you must deploy in...
Add a comment...

Post has attachment
Unable to connect/restart SQL Server service when deploying Log on as a service policy on SQL Server
Managed Service Account (MSA) is a special kind of domain account managed by a domain controller and is assigned to a single member computer and used for running services. The MSA password is managed by the domain controller. MSAs can register a Service Pri...
Add a comment...

Post has attachment
SQL Server - Check orphaned users in databases
An orphaned user is a database user whose corresponding SQL login has been dropped or the database is restored or attached to a different instance of SQL Server. You can detect orphaned users in a database by using the sp_change_users_login stored procedure...
Add a comment...

Post has attachment
Use Windows Authentication across multiple SQL Servers via linked servers by using Kerberos
If you are interested in allowing users to use Windows Authentication across multiple SQL Servers via linked servers, then Kerberos Constrained Deletgation is a feature in Active Directory Domain Services that can help you achieve the goal. In order to use ...
Add a comment...

Post has attachment
Precautions against Copy Database Wizard
The Copy Database Wizard will create an Integration Services package to copy or move database(s), there are a couple of things you need to be aware of: 1. You must select an Integration Services Proxy account that has access to the file system on both the s...
Add a comment...

Post has attachment
New built-in T-SQL features in SQL Server 2012 (compare with SQL Server 2008)
-- Date/Datetime Functions SELECT DATETIMEFROMPARTS(2012, 2, 12, 18, 10, 5, 997) SELECT DATETIMEFROMPARTS(2012, 2, 12, 18, 10, 5, 998) Be careful the millisecond part, 998 returns the same result as 997. Be careful the millisecond part, 999 returns the resu...
Add a comment...

Post has attachment
New Management Features in SQL Server 2012 (compare with SQL Server 2008)
--★★★-- -- FileTables FileTables are a special type of table that enables you to store files and documents within SQL Server 2012. These files and documents can be accessed from Windows applications as though they were stored normally in the file system. Fo...
Add a comment...

Post has attachment
TCP/IP Properties in SQL Server
Instead of specifying 1433 in the TCP Port text box of each IP type section , you can only specify it in IPAll section . You cannot specify 1433 in the TCP Port text box in the named instance when it is being used as default TCP port in the default instance...
Add a comment...

Post has attachment
Dynamic percentile stored procedure in SQL Server 2008
Here is the case, calculate percentile of data set in the excel, for example, the data set in the excel looks as below: ID C1 1 XXXX 2 XXXX 3 XXXX 4 XXXX 5 XXXX 6 XXXX 7 XXXX 8 XXXX 9 XXXX 10 XXXX In the SQL Server, it's very easy deal with the
data set wh...
Add a comment...

Post has attachment
SQL Server - Tuning performance of Project Server 2010 databases
Scenario As more users complain that different issues derived from the Project Server when managing projects and timesheets, the IT team has to spend more time troubleshooting issues. It not only downgrades users' working efficiency, it consumes internal re...
Add a comment...
Wait while more posts are being loaded