This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
Table 3.

SQL SERVER – Adding a Master Data Services to your Enterprise – Notes from the Field #072

March 19, 2015
Pinal Dave
SQL Tips and Tricks
BIML, Notes from the Field, SQL Server Security

Reeves Smith explains why you should add Master Data Services to your enterprise and why data governance is often overlooked in data warehouse projects.

Read More
SQL SERVER - Backup on mapped drive failing with error - Error 3201, Level 16, State 1

SQL SERVER – Backup on mapped drive failing with error – Error 3201, Level 16, State 1

March 18, 2015
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server

Backup on a mapped drive failing with Error 3201? The SQL Server service does not see the drive you mapped in Windows. Here is why, and what to do.

Read More
SQL SERVER - Marking Filegroup as ReadOnly with SQL Server

SQL SERVER – Marking Filegroup as ReadOnly with SQL Server

March 17, 2015
Pinal Dave
SQL Tips and Tricks
SQL Server Security

Readers asked how to mark a filegroup as ReadOnly. Here is a T-SQL script that creates a test database, adds a filegroup and marks it ReadOnly.

Read More
SQL SERVER - Interesting Observation with Currency Symbols

SQL SERVER – Interesting Observation with Currency Symbols

March 16, 2015
Pinal Dave
SQL Tips and Tricks

Did you know currency symbols like $ and £ are treated as money values in SQL Server? SELECT $ returns 0.00, and you can even use them in math.

Read More
Buttons grouped in a jar beside buttons arranged in an ordered row

Interview Question of the Week #011 – Script to Convert List to Table and Table to List

March 15, 2015
Pinal Dave
SQL Interview Questions and Answers

Convert a table to list with ordered STRING_AGG, split a list with STRING_SPLIT ordinals, and handle NULLs and empty tokens clearly.

Read More
Registry Editor.

SQL SERVER – SCRIPT – SQL Listening on Dynamic Port?

March 14, 2015
Pinal Dave
SQL Tips and Tricks
SQL Server Security

How do you know if SQL Server is listening on a fixed or dynamic port? Here is a script that reads the TcpDynamicPorts registry value for your instance.

Read More
SQL SERVER - Interesting Function AGENT_DATETIME

SQL SERVER – Interesting Function AGENT_DATETIME

March 13, 2015
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function

AGENT_DATETIME in msdb converts integer date and time values in YYYYMMDD and HHMMSS format into a datetime. Here is how it works, with examples.

Read More
File system task editor window.

SQL SERVER – The Basics of the File System Task, Part 1 – Notes from the Field #071

March 12, 2015
Pinal Dave
SQL Tips and Tricks
Notes from the Field, SSIS

Andy Leonard explains the basics of the SSIS File System Task, a handy tool when loading data to and from flat files. This is part 1 of the series.

Read More
SQL SERVER - Error - Msg 6401, Level 16: Cannot roll back Transaction

SQL SERVER – Error – Msg 6401, Level 16: Cannot roll back Transaction

March 11, 2015
Pinal Dave
SQL Tips and Tricks
SQL Error Messages

Is there such a thing as nested transactions in SQL Server? A simple demo shows why rolling back a named inner transaction fails with Msg 6401.

Read More
SQL SERVER - FIX - A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running. (Microsoft.AnalysisServices.AdomdClient)

SQL SERVER – FIX – A connection cannot be made to redirector. Ensure that ‘SQL Browser’ service is running. (Microsoft.AnalysisServices.AdomdClient)

March 10, 2015
Pinal Dave
SQL Tips and Tricks
Computer Network, SQL Error Messages, SQL Server

I opened SQL Server Management Studio and instead of a database engine. Below is the error which I received for SQL Browser:

Read More
Previous 1 … 269 270 271 272 273 274 275 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com