Useful tips for everyday
How do I view SQL Developer errors? control-shift-L should open the log(s) for you. this will by default be the messages log, but if you…
Which clause is used for pattern matching? WHERE clause LIKE Operator. The LIKE operator provides standard pattern matching in SQL that is always used after…
How do I fix SQL Server connection timeout? This work around may cause the timeout errors to stop but may not correct the root cause…
How do I check state server permissions? To grant the View Server State permission, follow these steps: Start SQL Server Management Studio. Expand Databases, right-click…
Where is SQL Server password policy? Navigate to the Security > Logins folder. Find the login you are interested in reviewing. Right click on the…
How do I select special characters in SQL query? Use braces to escape a string of characters or symbols. Everything within a set of braces…
How do you get a replacement character? The replacement character � (often displayed as a black rhombus with a white question mark) is a symbol…
How is data stored in a time series database? A time-series database lets you store large volumes of timestamped data in a format that allows…
How do I find blocked transactions in SQL Server? The second option in SQL Server Management Studio to monitor blocking is with the standard reports,…
How do I find an inactive ad account? To find the accounts, run a script that queries Active Directory for inactive user accounts. In Active…