Year archive
Posts from 2021
Blog posts
Stack Exchange answers
- Stack Exchange answer: Which install kit installs sqlcmd.exe?
- Stack Exchange answer: log_reuse_wait_desc = AVAILABILITY_REPLICA, log is 100% full but AG is all fine
- Stack Exchange answer: Order by one column if not null, otherwise by another column, columns are of not matching types
- Stack Exchange answer: Database context for sys.databases and sys.master_files
- Stack Exchange answer: decoding instance_name in sys.dm_os_performance_counters on Azure SQL Database
- Stack Exchange answer: SQL Server service - Not Starting With Automatic Startup, "The system cannot find the file specified", but starts fine manually
- Stack Exchange answer: Are Basic Availability Groups a reliable HA solution without integrity checks on the secondary replica?
- Stack Exchange answer: Why are there no "Daylight Time" time zones in SQL Server?
- Stack Exchange answer: How do I put the result of stored procedure in a new column in a view?
- Stack Exchange answer: Is it possible to do a partial transaction log backup with SQL Server 2017? I don't have enough disk space to do a full backup
- Stack Exchange answer: Can I use both Log Shipping and Transaction Replication at the same time?
- Stack Exchange answer: Database Sizes error; Arithmetic overflow error converting expression to data type int
- Stack Exchange answer: SQL Server replication additional subscriber
- Stack Exchange answer: Always backup database with encryption
- Stack Exchange answer: Partitioning and existing Indexes
- Stack Exchange answer: Identify how many CPUs our database server is using
- Stack Exchange answer: Function to create SQL TABLE does not works well using Powershell
- Stack Exchange answer: Is it ok to change drive names/labels (NOT Drive Letters!)
- Stack Exchange answer: Azure Data Studio - Intellisense does not detect tables, yet queries work
- Stack Exchange answer: insert on table being unnaturally slow
- Stack Exchange answer: What are the .BCP files inside a .bacpak file?
- Stack Exchange answer: Job to stop other job at specific time
- Stack Exchange answer: Getting the first Monday after the third Friday
- Stack Exchange answer: Why putting SQL Agent offline caused WSFC to fail over on passive node?
- Stack Exchange answer: Identify all tables with an identity column
- Stack Exchange answer: Question Regarding ISDATE Function and DATENAME Functions
- Stack Exchange answer: SQL Server 2012 equivalent of AT TIME ZONE capability
- Stack Exchange answer: Why does SQL Server convert floats to scientific notation?
- Stack Exchange answer: OLE DB provider "MSOLEDBSQL" with SQL Server not supported?
- Stack Exchange answer: When to partition table in SQL Server based on the amount of memory on server
- Stack Exchange answer: An expression of non-boolean type specified in a context where a condition is expected, near 'AND'
- Stack Exchange answer: SQL Server Configuration - Disabling the "Allow Remote Connections to this Server" Option
- Stack Exchange answer: How do I preserve leading zeros for varchar field?
- Stack Exchange answer: How to convert from nchar to decimal in SQL?
- Stack Exchange answer: View SQL Code Behind Flat File Import Wizard?
- Stack Exchange answer: Commit or rollback SQLServer-SQLTransaction when no data changed
- Stack Exchange answer: Why is part of transaction committed when stored procedure faults?
- Stack Exchange answer: Cardinality , Parallel Hint alternative for MS-SQL
Months
December
November
- Stack Exchange answer: log_reuse_wait_desc = AVAILABILITY_REPLICA, log is 100% full but AG is all fine
- Stack Exchange answer: Order by one column if not null, otherwise by another column, columns are of not matching types
- Stack Exchange answer: Database context for sys.databases and sys.master_files
- Stack Exchange answer: decoding instance_name in sys.dm_os_performance_counters on Azure SQL Database
October
- Stack Exchange answer: SQL Server service - Not Starting With Automatic Startup, "The system cannot find the file specified", but starts fine manually
- Stack Exchange answer: Are Basic Availability Groups a reliable HA solution without integrity checks on the secondary replica?
- Stack Exchange answer: Why are there no "Daylight Time" time zones in SQL Server?
- What the heck is the SSISDB? Where does it come from?
- Stack Exchange answer: How do I put the result of stored procedure in a new column in a view?
- Stack Exchange answer: Is it possible to do a partial transaction log backup with SQL Server 2017? I don't have enough disk space to do a full backup
- Stack Exchange answer: Can I use both Log Shipping and Transaction Replication at the same time?
- T-SQL Tuesday #143: My favorite short scripts
- What time is it in Oz?
- Stack Exchange answer: Database Sizes error; Arithmetic overflow error converting expression to data type int
September
- Stack Exchange answer: SQL Server replication additional subscriber
- Stack Exchange answer: Always backup database with encryption
- Stack Exchange answer: Partitioning and existing Indexes
- Stack Exchange answer: Identify how many CPUs our database server is using
- Stack Exchange answer: Function to create SQL TABLE does not works well using Powershell
- Stack Exchange answer: Is it ok to change drive names/labels (NOT Drive Letters!)
August
- Stack Exchange answer: Azure Data Studio - Intellisense does not detect tables, yet queries work
- Stack Exchange answer: insert on table being unnaturally slow
- Stack Exchange answer: What are the .BCP files inside a .bacpak file?
- Stack Exchange answer: Job to stop other job at specific time
- Stack Exchange answer: Getting the first Monday after the third Friday
- Stack Exchange answer: Why putting SQL Agent offline caused WSFC to fail over on passive node?
July
June
- Stack Exchange answer: SQL Server 2012 equivalent of AT TIME ZONE capability
- Stack Exchange answer: Why does SQL Server convert floats to scientific notation?
- Stack Exchange answer: OLE DB provider "MSOLEDBSQL" with SQL Server not supported?
- Stack Exchange answer: When to partition table in SQL Server based on the amount of memory on server
- Stack Exchange answer: An expression of non-boolean type specified in a context where a condition is expected, near 'AND'
- Stack Exchange answer: SQL Server Configuration - Disabling the "Allow Remote Connections to this Server" Option
May
April
March
No months selected. Select one or more months to show posts.
Tags
Automation
Availability Groups
Azure
Azure Data Studio
Backup & Recovery
Dates & Time
DBA Database
- Querying SERVERPROPERTY() and DATABASEPROPERTYEX() from a view (without knowing magic)
- Stack Exchange answer: log_reuse_wait_desc = AVAILABILITY_REPLICA, log is 100% full but AG is all fine
- T-SQL Tuesday #143: My favorite short scripts
- What time is it in Oz?
- Stop using sp_hexadecimal & sp_help_revlogin
Indexes
Internals
Log Shipping
Performance
PowerShell
Programming
Querying
- Querying SERVERPROPERTY() and DATABASEPROPERTYEX() from a view (without knowing magic)
- Stack Exchange answer: How do I put the result of stored procedure in a new column in a view?
- Stack Exchange answer: An expression of non-boolean type specified in a context where a condition is expected, near 'AND'
- Stack Exchange answer: View SQL Code Behind Flat File Import Wizard?
- Stack Exchange answer: Why is part of transaction committed when stored procedure faults?
Replication
Security
Shortcuts
SQL Agent
SQL Server
- Stack Exchange answer: Which install kit installs sqlcmd.exe?
- Stack Exchange answer: Order by one column if not null, otherwise by another column, columns are of not matching types
- Stack Exchange answer: Database context for sys.databases and sys.master_files
- Stack Exchange answer: SQL Server service - Not Starting With Automatic Startup, "The system cannot find the file specified", but starts fine manually
- Stack Exchange answer: Database Sizes error; Arithmetic overflow error converting expression to data type int
- Stack Exchange answer: Is it ok to change drive names/labels (NOT Drive Letters!)
- Stack Exchange answer: What are the .BCP files inside a .bacpak file?
- Stack Exchange answer: Getting the first Monday after the third Friday
- Stack Exchange answer: Identify all tables with an identity column
- Stack Exchange answer: Why does SQL Server convert floats to scientific notation?
- Stack Exchange answer: OLE DB provider "MSOLEDBSQL" with SQL Server not supported?
- Stack Exchange answer: When to partition table in SQL Server based on the amount of memory on server
- Stack Exchange answer: SQL Server Configuration - Disabling the "Allow Remote Connections to this Server" Option
- Stack Exchange answer: How do I preserve leading zeros for varchar field?
- Stack Exchange answer: Commit or rollback SQLServer-SQLTransaction when no data changed
SQL Tooling
Statistics
T-SQL
T-SQL Tuesday
Transaction Logs
What the Heck Is
Windows
No tags selected. Select one or more to show posts.
Categories
Databases
- Querying SERVERPROPERTY() and DATABASEPROPERTYEX() from a view (without knowing magic)
- Stack Exchange answer: Which install kit installs sqlcmd.exe?
- Stack Exchange answer: log_reuse_wait_desc = AVAILABILITY_REPLICA, log is 100% full but AG is all fine
- Stack Exchange answer: Order by one column if not null, otherwise by another column, columns are of not matching types
- Stack Exchange answer: Database context for sys.databases and sys.master_files
- Stack Exchange answer: decoding instance_name in sys.dm_os_performance_counters on Azure SQL Database
- Stack Exchange answer: SQL Server service - Not Starting With Automatic Startup, "The system cannot find the file specified", but starts fine manually
- Stack Exchange answer: Are Basic Availability Groups a reliable HA solution without integrity checks on the secondary replica?
- Stack Exchange answer: Why are there no "Daylight Time" time zones in SQL Server?
- What the heck is the SSISDB? Where does it come from?
- Stack Exchange answer: How do I put the result of stored procedure in a new column in a view?
- Stack Exchange answer: Is it possible to do a partial transaction log backup with SQL Server 2017? I don't have enough disk space to do a full backup
- Stack Exchange answer: Can I use both Log Shipping and Transaction Replication at the same time?
- T-SQL Tuesday #143: My favorite short scripts
- What time is it in Oz?
- Stack Exchange answer: Database Sizes error; Arithmetic overflow error converting expression to data type int
- Stack Exchange answer: SQL Server replication additional subscriber
- Stack Exchange answer: Always backup database with encryption
- Stack Exchange answer: Partitioning and existing Indexes
- Stack Exchange answer: Identify how many CPUs our database server is using
- Stack Exchange answer: Is it ok to change drive names/labels (NOT Drive Letters!)
- Stack Exchange answer: Azure Data Studio - Intellisense does not detect tables, yet queries work
- Stack Exchange answer: insert on table being unnaturally slow
- Stack Exchange answer: What are the .BCP files inside a .bacpak file?
- Stack Exchange answer: Job to stop other job at specific time
- Stack Exchange answer: Getting the first Monday after the third Friday
- Stack Exchange answer: Why putting SQL Agent offline caused WSFC to fail over on passive node?
- Stop using sp_hexadecimal & sp_help_revlogin
- Stack Exchange answer: Identify all tables with an identity column
- Stack Exchange answer: Question Regarding ISDATE Function and DATENAME Functions
- Stack Exchange answer: SQL Server 2012 equivalent of AT TIME ZONE capability
- Stack Exchange answer: Why does SQL Server convert floats to scientific notation?
- Stack Exchange answer: OLE DB provider "MSOLEDBSQL" with SQL Server not supported?
- Stack Exchange answer: When to partition table in SQL Server based on the amount of memory on server
- Stack Exchange answer: An expression of non-boolean type specified in a context where a condition is expected, near 'AND'
- Stack Exchange answer: SQL Server Configuration - Disabling the "Allow Remote Connections to this Server" Option
- Stack Exchange answer: How do I preserve leading zeros for varchar field?
- Stack Exchange answer: How to convert from nchar to decimal in SQL?
- Stack Exchange answer: View SQL Code Behind Flat File Import Wizard?
- Stack Exchange answer: Commit or rollback SQLServer-SQLTransaction when no data changed
- Stack Exchange answer: Why is part of transaction committed when stored procedure faults?
- Stack Exchange answer: Cardinality , Parallel Hint alternative for MS-SQL
Tools & Automation
No categories selected. Select one or more to show posts.